Control Flow Task and variables considerations for boosting performance

Several considerations can be applied to get even more performance from SSIS packages. To take control and make it possible, firstly you need to know the present performance in order to monitor and evaluate every step for boosting the performance. One important consideration when implementing SSIS projects is to avoid doing all the work in just one or a few packages. Splitting the work into several packages gives more flexibility for future troubleshooting and reduces risk when a change must be applied. Other considerations can be:

• Design the Control Flow in order to have tasks executing in parallel. If some of the tasks have precedent constraints and you cannot execute in parallel, make use of the the Sequence Container. In this way it is possible to execute some tasks in parallel (inside the container) and have others executed after the container's execution (the container status can be Completed, Success, or Failure...