CDC Source timeout and transaction intergrity

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

July 31st, 2015 3:36am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics