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 parallelism

This section will now focus on how we can enhance the performance of our package execution. Using parallelism in SSIS is very easy. A simple use of parallelism is in the entrypoint packages. Other parallelism can be implemented in the data flow tasks by using multiple source and destination components. In fact, every source we use in a data flow task has its own thread in SSIS, meaning that SSIS will try to execute all source transforms at once using different hardware resources.

In this recipe, we'll complete the entry-point package for the DW schema load. In this package, we have linked the dimensions together first. We now think that there are no dependencies between them and we'll separate them.

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