Im having issues with an ssis package that processes change from a source db to a destination db. The package is set up to only process net changes and has multiple tables being loaded simultaneously.
The task sequence is 1) mark initial load start, 2) Mark initial load end, 3) Get processing range, 4) Mark Processing range. The package runs the initial load and the first incremental successfully (the first incremental is an update for rows that were added to source system whilst the initial package was loading). Then all subsequent incrementals fail as they try to insert duplicate rows into destination primary keys.
The cdc state variable sequence is;
I cant understand how duplicate rows are making it through to the destination. Any ideas where I have gone wrong?
thanks in advance