Archive for January 20th, 2010

Speeding up Reading from a SQL OLE DB or ADO.Net Data Source (2010-1-20)

With small datasets on a test system you will probably hardly notice the difference, but when you are building SSIS packages that need to process Gigabytes of data in a production environment on a day to day basis, the following Performance tip to optimize reading from the SQL data source is one to remember.  1) […]