Thanks very much for your reply. Very helpful.

Looks like there's no real elegant way to do this (besides going through teh trouble to write a custom script) although I think I'll try the Merge Join - Conditional split.

It's really too bad SSIS doesn't support this in a regular Merge Join component...

In playing around, I have been just saving the values to a Temp table, and then doing my own update in the Control flow where I can then write in the sql code for the join, but this just breaks up all the processing and is really a work around.

Thanks!!

Sarah