I have an SSIS package that sets up CDC in a SQL 2008 by looping through a series of tables and activating each using the following basic command: EXECUTE sys.sp_cdc_enable_table @source_schema = N’dbo’
Below you'll find a list of all posts that have been tagged as “Data Warehouse”
I have an SSIS package that sets up CDC in a SQL 2008 by looping through a series of tables and activating each using the following basic command: EXECUTE sys.sp_cdc_enable_table @source_schema = N’dbo’