The SSIS CDC components are used to provide the change data in a way that is easy to further process it for replication, loading a data warehouse, updating slowly changing dimensions for OLAP, ...

MS SQL Server Change Data Capture (CDC) Demo MS SQL Server is one of the most popular databases in the corporate world.