davecason Commented 2 Years ago through
Blogs
I benchmarked a bunch of these SQL Server ETL methods and bcp and bulk insert came up near at the bottom on performance. SSIS was, by far, the fastest way to move data into a SQL Server, and it was relatively easy to make parallel transactions to "fill...