I've got a Data Flow that I am Conditionally splitting twice. DataSource is SQL2k DB, and Destination is SQL2k8 DB.
First Split is to see if a record exists in the Destination: No goes to Merge 1 and Yes goes to Second Split.
Second Split is to see if the record matches (description field): Yes goes nowhere, and No goes to Merge 1.
Merge 1 feeds an OLE DB command that is supposed to insert the reocrd into the table (that I've been comparing the Data Flow to in the prior Splits).
The desired behavior is that the Merge would feed results to the OLE DB command and insert the record. What is happening is that the Data Flow is being partially processed and the OLE DB command goes 'Green' before all the data is 'Merged'.
There are about 16k records in the incoing Data Flow.
Switching to OLE Destination doesn't change anything, because the output from the Merge never outputs any of the records, even though there are 81 records shown in Split 1's Lookup No Match Output.
Any ideas? Am I using this control incorrectly? Is there a better way to do this?