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/sqlp 
Leggi tutto il post...