Runying Mao e Len Wyatt hanno effettuato una serie di test sulle prestazioni di SSIS e pubblicato i risultati in questi post:
Getting Optimal Performance with Integration Services Lookupshttp://blogs.msdn.com/sqlperf/archive/2007/04/24/getting-optimal-performance-with-integration-services-lookups.aspx
OLEDB Source with Views http://blogs.msdn.com/sqlperf/archive/2007/04/29/set-up-ole-db-source-to-read-from-view-efficiently.aspx
BLOB and buffer temporary storagehttp://blogs.msdn.com/sqlperf/archive/2007/05/01/set-blobtempstoragepath-and-buffertempstoragepath-to-fast-drives.aspx
SSIS Performance Countershttp://blogs.msdn.com/sqlperf/archive/2007/05/01/something-about-ssis-performance-counters.aspx
Buffer size adjustmentshttp://blogs.msdn.com/sqlperf/archive/2007/05/11/adjust-buffer-size-in-ssis-data-flow-task.aspx
Parallel executionhttp://blogs.msdn.com/sqlperf/archive/2007/05/11/implement-parallel-execution-in-ssis.aspx