ETL 2 million rows – Comparison of BULK INSERT, BCP, OLEDB, ADO NET, OPEN ROWSET, SQL Server Destination task

A quick video comparing the performance of different ETL options when importing 2 million rows into a database. All tasks use the BULK Logged Options where possible.

ETl method performance

Have you seen this link on the ETL world record using SSIS?

https://msdn.microsoft.com/en-us/library/dd537533.aspx

Summary

MethodTime
Bulk Insert28 sec
DFT OLEDB – 5001:13 sec
DFT OLEDB -950035 sec
SQL Server Destination15 sec
ADO NET1:20 sec
bcp40 sec
Openrowset36 sec