Posts Tagged ‘tuning’

Reading as fast as possible from a table with SSIS (Part II) (2010-5-13)

Recently I blogged on how to be as selective as possible while reading from and OLE DB Data Source (Part I) and how to load the data from a single flat file as fast as possible into a SQL Server table. But you probably noticed that “Out of the box” SSIS reads data faster from […]

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) […]