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

Please Consider Subscribing

Subscribe