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.