Intermediate SSIS

  • Guy Fouché
  • Lynn Langit


By now, you’ve translated your business requirements into an SSAS cube. The next task in implementing your BI project is to execute an ETL solution from your detailed data map. As discussed in Chapter 7, data maps are used as a basis for beginning ETL design. In our experience, a good deal of the initial work on a BI project consists of ETL process design, development, and debugging. We assume that you’ve completed your data map and created a simple package or two using the Import and Export Wizard or by using the SSIS package template in BIDS. In this chapter, we’ll cover the following topics:
  • Considering common ETL package-design practices

  • Understanding control flow tasks

  • Understanding data flow transformations

  • Using the Dynamic Configuration Wizard and property expressions


Control Flow Data Flow Precedence Constraint Design Surface Sample Package 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Guy Fouché and Lynn Langit 2011

Authors and Affiliations

  • Guy Fouché
  • Lynn Langit

There are no affiliations available

Personalised recommendations