Posts Tagged ‘tuning’

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

Category: Performance tip, SQL 2008 R2, SSIS | Tags: , , | 22 Comments

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)

Category: SSIS | Tags: , , | 10 Comments

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

Better Tag Cloud