July 25, 2013 at 10:11 am
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
July 29, 2013 at 7:08 am
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..
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