Hi All,

I have created a SSIS Package which does the incremental update using CDC Controls.

The design is similar to any standard CDC incremental package.

It has a CDC Start which sets the Mark Processing Range, a data flow and a Mark Processed Range.

The issue that i'm facing is that the CDC Source control time-out but i can still see rows moving from CDC Source to Splitter and target table. After the rows are transferred, the Data Flow task Fails which leads to package failure.

This results in Mark Processed Range not being executed.

So my query is

1. Why is CDC Source being time-out?

2. What can i do so that all three i.e Mark Processing Range, data flow and Mark Processed Range execute successfully or nothing does.

T

Hi Liquidloop,

Please set the RetainSameConnection property of the source connection manager to true.

Hi Liquidloop,

As per my understanding, may be the response time from the database is very slow that longer than the default time 30 seconds in CDC Source, so it timeout.

To work around this issue, we can change the CommandTimeout property from 30 to a bigger one. Because the CommandTimeout property value indicates the timeout (in seconds) to use when communicating with the SQL Server database. This value is used where the response time from the database is very slow and the default value(30 seconds) is not enough.

Besides, please select appropriate processing mode to best handles your processing needs. For more details, please see:
http://www.mattmasson.com/2012/01/processing-modes-for-the-cdc-source/

Thanks,
Katherine Xiong