Thanks for the info. That link should prove to be a pretty good guide if I need to performance tune some of this later.

Maintainability is the trump card on this because it's going to get handed over to a non sql guy down the line. Hence the desire to keep as much in SSIS as possible. He'll muddle through some SQL if he has to but the easier and more "GUIfied" I can make it for him the better.