Change data capture (CDC) technology has become a strategic component of many data warehouse and business intelligence (BI) architectures. Given today's ever increasing struggle for more immediate access to real time data and information, constant pressure on efficiency costs, and the exponential growth of underlying data volumes, CDC is now a "must have" for the modern BI and data warehouse project. Furthermore, when combined with the very comprehensive, powerful and competitive ETL offerings of Microsoft SQL Server Integration Services (SSIS), the cost-benefits of an architecture based on a combination of CDC and SSIS are now hard to ignore.

Read this paper and learn how to use change date capture technology with Microsoft SQL server intergration services to access real time data and information quickly while keeping costs low at the same time.