August 1, 2017 at 12:38 am
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
August 1, 2017 at 3:18 am
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
April 3, 2019 at 8:34 am
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