Extreme slow data load with SSIS

In some cases it can take extreme long time to transfer data with the OLE DB Source component.

When we use the Data access mode: Table or view, you get a “Select * from …” using the OpenRowSet which can result in an inefficient execution plan, with give us a slow query performance.

If we instead using Data access mode: SQL command, we get an SQL Prepare instead with much better performance.

Then we also have the possibility to specify the columns you want and then get a more robust solution.

/Christian