Vi allego un link sulle 10 best practices di SSIS.Riassumento sono le seguenti:1 - SSIS is an in-memory pipeline, so ensure that all transformations occur in memory.2 - Plan for capacity by understanding resource utilization.3 - Baseline source system extract speed4 - Optimize the SQL data source, lookup transformations, and destination5 - Tune your network6 - Use data types – yes, back to data types! –wisely7 - Change the design8 - Partition the problem9 - Minimize logged operations10 - Sched 
Leggi tutto il post...