Is there any way of configuring the CDC Source and CDC Splitter programmatically? I have coded the CDC Initial load to programatically go through a list of tables and bring across all of the data for each specified table I would like to do the same with the CDC Source and CDC splitter controls in a DataFlow task - i.e. put them into a ForNext container and loop around a list of table names, with the DataFlow task bringing across all of the Changed records for the table - and putting into destination tables Is this possible - or do i have to "hand-code" a new DataFlow task for each (and every) table that i want to capture / bring the data across for ?? (or if not possible, is that why theCDC examples i have seen have only one table in ???!!???)

The CC Source is Connection Manager driver, so you must be able to parametrize the connection string say using a variable or better a configuration. With CDC Splitter I do not see any APIs provided, but also seems to me a component that does not require any settings, why would you need it to be programmatically changed?Arthur My Blog

Arthur, agree about the CDC Source being a connection manager - dont think i have a problem there as all the tables are in the same DB and the ADO.Net connection manager should be ok for that. agree about the CDC Splitter - that will (hopefully :) ) work out the columns etc to process based on the table being processed by the CDC Source from my (small) understanding, what i need to be able to set programmatically is the value in the [CDC Source].[CaptureInstance] property of the dataflow task - ideally from the ControlTask - ideally, the control task will get a list of all the tables that are to be processed by CDC - and then iterate through the list passing the name of each one down to the [CDC Source].[CaptureInstance] property of the dataflow task am still at initial thnking / designing stage - so if this is not possible - or best way, am open to alternatives .......

ooooooooooooooooooooooooops pls ignore the above - think have solution (currently developing / testing)