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