When you start moving large volumes of data, tuning SSIS will become very important. This video tutorial outlines the importance of Blocking, Partial Blocking, & Non -Blocking transformations and how to design packages so they will run faster.

I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-...