Synchronize two tables using SQL Server Integration Services (SSIS)-Part II of II

Please, refer to this link for the first part of this post. In this part we will start with the same sample scenario where “table A” in “database A” needs to be synchronized with “table B” in data warehouse “database B”. During the first part of this post we discussed how to deal with new…

1

Synchronize two tables using SQL Server Integration Services (SSIS)–Part I of II

There are situations where a SQL Server DBA needs to keep two different tables in sync. Usually, the DBA needs to keep a copy of a table in a in a data warehouse repository that is used as a solution for archiving and/or reporting. SQL Server provides a robust method for keeping data synchronized across…

7