CDC - SQL Data Tools on multiple table

• Sreejith Sreedharan

  SSCertifiable

  Points: 5403

  More actions

  July 25, 2013 at 10:11 am

  #277942

  I trying to use the CDC functionality to pull data from multiple tables. I have two packages(One for Init Load and One for Incremental Load) per table and a wrapper package that call Individual SSIS. I have set up the states to be stored at the source db.

  Where should I have the "Mark Initial Load Start" and "Mark Initial Load End"? If I do it at every package(table), how will it affect incremental loads? Should I do "Mark Initial" and "Mark Incremental" just once not at table level.

  I am yet to find an article that shows how it can be done for multiple tables.

  Thanks

  Sreejith

• rajborntodare

  Hall of Fame

  Points: 3576

  More actions

  July 29, 2013 at 7:08 am

  #1636619

  I am yet to find an article that shows how it can be done for multiple tables.

  Thanks

  Sreejith

  Hi Sreejith,

  Did you find this link..

  https://www.simple-talk.com/sql/learn-sql-server/introduction-to-change-data-capture-%28cdc%29-in-sql-server-2008/

  I was asked to create CDC for entire DB..

  I refered from this link.. that was so helpful and my job was done...

  follow the instructions and customize them to your environment.

  Just adding little information.. :hehe: