Dear Jamie,
I just wanted to get some feed back from you about performance in Integration Services. I've been using it for two months and I have created a package that should pump 2.5 million records from my source to my destination. Now I will say that I have several steps of sorting (Using the sort component) and merge join (using the merge join component). But my performance is horrible. I used the methodology outlined in your Article: " New ETL Paradigm" I saw this component from ivolva.com which they created as a third party component called extra sort. It says it speeds up sorting. Do you have ANY suggestions???
Thank you,
Mag