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

How it works...

By setting the number of worker threads to its minimum value, you have made certain that this data flow will not be parallelized. By using a number greater than 2, you instruct the SSIS execution engine to try to assign more than one thread to the data flow.

Note though, that at run time the SSIS engine might assign fewer (or more) threads than specified at design time—it takes into account the actual needs of a particular data flow (for instance, the size of the data, the complexity of the transformations, and so on), and it also considers the availability of resources (that is, the actual number of available worker threads, the actual amount of memory that can be allocated to this particular data flow, and so on).

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