Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Incremental Data Loading Using CDC Expand / Collapse
Author
Message
Posted Wednesday, June 12, 2013 8:23 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 12:10 PM
Points: 49, Visits: 279
I did some testing.
added the reprocessing column option to the cdc source.
Performed a couple changes in DDL and DML over the tracked table.
Ran the CDC update package which failed. The time out was 520 for the test.
The incremental CDC package would now fail with 1 warning about reprocessing mode and a time out error.
Truncating the target table and running a 10 min initial load was the only way I found to get the incremental update to work again.


BI Guy
Post #1462885
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse