Sorry, lack of coffee this am caused the word 'Split' to be used in place of the word 'Lookup'. Yes, I am using look-up matching to separate the data flow into three sets. I was hoping to merge the two conditions that would warrant insertion of a new row into a single data flow before using OLE DB (command or destination) to insert the record.

I am surmising that this has something to do with caching, although that idea only comes from watching the order in which the steps ghange from yellow to green. Why is the OLE DB (command or destination) turning green before the (prior step) merge has finished merging?