DCSIMG
Data Flow Task - Yaniv Mor

Yaniv Mor

On SQL Server and Business Intelligence

Browse by Tags

All Tags » Data Flow Task (RSS)
SSIS Performance – The OLE DB Source Adapter
Technorati Tags: SSIS , Data Flow Task I came across a BOL topic discussing SSIS data flow optimization techniques . For the OLE-DB source component there is a recommendation to use a SELECT statement instead of the "Table or View" access mode. For the sake of clarity, when you use the "Table or View" access method, you get to choose a specific table or view from the database you have designated as your source database, in a drop-down list. When you use the "SQL Command"...