O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required