Thanks for your suggestion 🙂

We are using SQL Server version 2005, Merge Statement is Not Supported.

Please share if anybody has used the below approach for their ETL

Begin Transaction

Lock Table Sales

EXEC sp_rename 'Sales', 'Sales_temp';

EXEC sp_rename...

Thanks for the reply. We are using SSIS Lookup transformation and OLEDB Command to update the records in the target table.

The Size of the target table is 4o Lakhs currently....