Change Data Capture w/o the SQL Server 2008 Relational Engine

November 13, 2008

With the arrival of SQL Server 2008 we gained access to a new feature called Change Data Capture (CDC). CDC enables you to constantly stream change data to a consuming process, most notably Extract, Transform, and Load (ETL) applications. In the SQL Server environment the ETL application used is of course SQL Server Integration Services (SSIS).

The article continues at http://www.sqlmag.com/Articles/Index.cfm?ArticleID=100797