SSIS Upsert (Insert/Update)

  • Can someone please advise the best approach to implement the UPSERT operation (Insert/Update) in SSIS?  I Have around 100k records and implemented lookup transformation, older command for insert and update.  this approach takes more than 3 hours to load the data.  I use SP in older command.

    Thanks
    Mohammed

  • Personally, I find the easiest way is to insert the data into a staging table, and then use a MERGE statement, or a INSERT/UPDATE statement. SSIS does have tools to do "Upserts", but there's a lot of hoops to jump through, and you'll porbably find your SQL Server's Data Engine is better at it.

    If your Insert/Update statement is show, then possibly it would instead be worth investing some time in looking at that and why it's slow.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • Hello SuhaibV

    You can read about SSIS Upsert (Insert/Update)  in our blog. If any questions remain after reading the article or some new appear, please ask us we will answer you shortly.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply