The issue with all at once large data loads is log file growth. the best way to deal with that is to chunk out the load into small sets with a commit after each. SSIS does this for you.