O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

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

Using the master package concept

By using the master package concept, it is possible to parallelize the execution of multiple child packages as determined in the control flow of the master package. Typically, this approach is used to parallelize packages that use separate data sources and data destinations (for instance, processing separate dimension tables in data warehousing scenarios), or to parallelize packages with CPU-intensive operations to run concurrently with packages with I/O-intensive operations.

In the control flow, you use precedence constraints and containers to determine which operations can be performed in parallel, and which of them must be performed in sequence. Through the MaxConcurrentExecutables package property, you ...

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