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 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 task has to complete before the other starts, as shown in the following screenshot:
  1. From the SSIS toolbox, add a sequence container to the package's control flow and name it seq_Dimensions.
  2. Delete the link between the fact-tables container and the dimension.
  3. Select all the dimensions and drag them into the newly added sequence container.
  4. Delete all the links between the dimensions.
  5. Now, link the seq_Dimensions sequence contained in the fact ...

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