I have created this blog to learn more and more about SSIS and Sql server.
Here you will find posts about Control Flow Task, Data flow transformation and lot more. I have tried to explain transformations and tasks through simple scenario and example.
I hope this would help you

For updating the table, I used OleDBCommnad transformation, for insertion it was directly inserting the row into OleDB destination, on the basis of the availability of Business Key in the destination table

The below is the snapshot of the SCD method I

As we all know , that SCD is very slow , when it comes to update the existing records, so when I executed the DFT for loading ‘tmpdimDest’, It was taking lot of time to do the update and insert operation. As update operation was involving comparison of all 600 columns and updating all the 600 columns.

The question comes here, is why the SCD or OleDB Command becomes slow while update operation?

And the Answer is “Because OleDB command performs operation (like Insert, update delete) for each row, so when there is huge number of records then it takes long time to perform the operations”

Question: So what are the alternatives of the combination SCD and OleDb Command operation?