• Phil,

    As always, thanks for your input, or.... Conditional Input... BUAH!!! LOL...

    I checked this out and its totally cool; however, I have another question (just like a 6 y/o).. My conditional Column from the source table is called "Fruit" for this example. If the Condition says Fruit == "Apple" and I add my OLD DB Destination based on Apple, if there is no "Apple" Data to push, will the OLE DB Destination container fire off? If so, that's wasted processing time which I want to avoid. I have to do this 13 times. The Data Access Mode will be an SQL Command that queries the landing table with the source table to make sure no duplicates are pushed. The landing table is REALLY large in all cases and I need to limit how often/how long that table is getting hit as it has a direct impact on customers.

    Also... I know this is stupid but why... why why why do we use single quotes to enclose a string everywhere else in SSMS, but in the conditional split conditions we use double quotes?

    again... thanks for the assists... you always help if you can.

    Crusty.