Fundamentally, Change Data Capture (CDC) allows you to load just those changes that have been applied to data in a source system since the last time you loaded data from it, without having to make any schema changes to the source system in order to track them. This has obvious uses in the data warehousing world, where requesting a full load of a large source system's data or altering its schema is impractical, and you need just the data since the last time you loaded it.
SSIS 2012 introduces three new components to reduce the complexity of the plumbing required to create a CDC-based data loading system. Those components are:
CDC Control Task: This new component is used to manage the lifetime, or scope, of a change data capture session. It can automatically record first load start and end points for a CDC load and retrieve or record the range of CDC values that are processed. It is found on the task toolbar for the SSIS Control Flow tab in SQL Server Data Tools...