Wanted to stroll interested (best suggestions) posts on the forums here and recently this 25701 topic has very good tips & tricks in managing performance your Integration Services packages that will need to deal huge number of rows (such as in millions!).