Hi Akshay,

I wouldn't use a OLE DB Command, it is extremly slow for large datasets. It will perform the updates row by row. It is a good exercise for you to make it and test it.

You can also use a Temp Table and then make a batch update using an Execute SQL Task, but at the end I bet that you will use the MERGE solution.

Further question, just write back!