Just to add to what Jeffrey said, if performance is of primary concern and you have a little time to tune the SSIS you can play around with adjusting the SSIS buffer sizes on your Data Flow to get maximum throughput. Reference: DefaultBufferMaxRows and DefaultBufferMaxSize
Adjust buffer size in SSIS data flow task by SQL Server Performance Team
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato