I am using the CDC objects in SSIS to do replication between two servers
I have a large table that does not have a Primary key so must be set to all.
Occasionally when I do validation between the two, the record count is correct but values don't add up.
I am doing a simple update from the CDC splitter to the destination table.
Is it possible that the CDC splitter is not applying changes in proper sequence?
There is very little documentation on these CDC objects in SSIS
both servers are fully patched to latest SQL 2016 Ver. and SSIS is running from a fully patched SQL 2017.
Who is the expert on Change Data Capture?