Interesting. You say that this improved 10 minutes from using a Merge Join - that doesn't surprise me. I'd be more interested in knowing if there is a performance improvement/degredation compared to simply running it as a SQL statement.

Can I also ask why you chose to implement as a data flow given that you already had it working in T-SQL?

-Jamie