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’