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.
Have you seen this link on the ETL world record using SSIS?
https://msdn.microsoft.com/en-us/library/dd537533.aspx
Summary
| Method | Time |
| Bulk Insert | 28 sec |
| DFT OLEDB – 500 | 1:13 sec |
| DFT OLEDB -9500 | 35 sec |
| SQL Server Destination | 15 sec |
| ADO NET | 1:20 sec |
| bcp | 40 sec |
| Openrowset | 36 sec |
Please Consider Subscribing
