Keep in mind that when using data flows in SSIS, the data has to go from the source server to the SSIS server and then to the destination server. This mean that you also have to consider the network traffic,along with the memory and CPU usage.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]