Koen, thank you for this. Very helpful!

In the custom implementation example, is that a Merge or a Merge Join?

If it's simply a Merge, can I use the Union All instead?

In SSIS 2005 you need to sort the source before Merging it, which might cause performance issues. What do you think?

Thanks

Romina