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.

Getting ready

This recipe assumes that you have access to this book's sample solution.

How to do it...

1. From the SSIS.Etl project, open the EP.D_Sequential package from the solution explorer.
2. You'll see that all dimensions are called in sequence, one after the other. An execute package...