CDC - SQL Data Tools on multiple table

  • 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

  • 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:

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply