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 'Sales_Swap', 'Sales';

EXEC sp_rename 'Sales_temp', 'Sales_Swap';

End Transaction

Thanks,