Add-on for SSIS: Enhanced SQL Server SSIS

How Change Data Capture Works for CONNX with SSIS and SQL Server.

Microsoft SSIS package can easily harvest the change data in the SQL Server database to perform efficient incremental loads to a data warehouse. DataSync will need to be enabled before you can use SSIS to load change data, you must enable change data capture on the database and the tables from which you want to capture changes. DataSync will be a pull down option from within SSIS. Once change data capture is enabled on the database, you can create a package that performs an incremental load of the change data. This enhanced SQL Server SSIS product allows for connection to any of the supported CONNX databases.

The diagram on the sidebar shows the steps for creating such a package that performs an incremental load from a single table.