Am doing a proof of concept for usage of SSIS CDC component.
For initial load: What I got so far is
step 1: CDC Control Task with CDC Control Operation as : Mark Initial load start step 2: Data flow to load all source records to destination step 3: CDC Control Task with CDC Control Operation as : Mark Initial load end (rest of setting as of CDC in Step 1)
When I run first time ... all data loads fine. If run the same ... instead picking none records (no change in source) ... its reloads all the records again ... duplicating.
Does this doesn't check in CDC State table created in step 1.
Anyone can point me to good sample or tutorial would be great.
Yes I got it .. what I was doing wrong was I created a single package to do all initial load and incremental load. And other thing was I didn't created a step for 'Mark CDC Start' after initial load. Now I got one package which does full initial loads and then Marks CDC start. Then from there onwards my second package to do incremental load starts.