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 speed
4 - Optimize the SQL data source, lookup transformations, and destination
5 - Tune your network
6 - Use data types – yes, back to data types! –wisely
7 - Change the design
8 - Partition the problem
9 - Minimize logged operations
10 - Schedule and distribute it correctly

per capire meglio questi punti vi invito a vedere qui.

Stay Tuned!