If you are not already aware of it, a good read on the subject of ETL can be found in the "Stairway" section on this website. Look for "Stairway to SSIS" and so forth.

And don't forget to check Books Online.