I have a table set up for CDC The CDC source object in SSIS is set to all because the table does not have a primary key. I have eliminated the Splitter object to try to address this issue. and am using a stored proc to process the inserts / updates and deletes. This is fairly straight forward code. I keep intermittently missing record changes.