När du försöker köra ett SQL server Integration Services (SSIS) paket i Business Intellegence Studio…
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.