Change Data Capture support
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 ...
Get What's New in SQL Server 2012 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
