We are using SSIS for ETL purpose. There is a shortcoming in SSIS as it doesn't provide any in built component which will bulk upsert the destination. The alternative to it to use Staging tables which is not an option as we already discarded it from maintenance perspective. While exploring the market we found ZappySys's "SSIS Upsert Destination" component which might fulfill our requirements.

Having said that, there is a caveat that it uses temporary tables as Staging tables and do the operations like upsert. Since we would be dealing with millions of rows, it is something which is not normal in our environment to use tempdb for such workload and might not be recommended.

So do we need to consider anything before proceeding with it? Anyone using the above mentioned component who can share the experience?


  • 1
    I'd ask myself the question - do I want to control the creation and population of temporary tables to perform upserts or rely on a third party component to do so? – billinkc Aug 4 '20 at 14:00
  • @billinkc Thanks. I can totally understand your point, but unfortunately in our environment such control is not possible. – NOOK Aug 4 '20 at 20:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.