Home > Sample chapters > Programming > SQL Server

Implementing a Data Warehouse with Microsoft SQL Server 2012: Dynamic Packages

Case Scenario

In the following case scenarios, you apply what you’ve learned about implementing dynamic packages. You can find the answers to these questions in the “Answers” section at the end of this chapter.

Case Scenario: Making SSIS Packages Dynamic

You are creating a set of SSIS packages to move data from flat files and different databases to a data warehouse. Because of strict development, test, and production procedures, your SSIS project must support these possibilities:

  1. You need to test different deployment options for your SSIS packages in the development phase by using SSDT.

  2. You have a development, test, and production environment and would like to minimize any changes to packages when they are ready for the test phase.

  3. You need to parameterize the location of the flat files but still be able to dynamically set the correct file name when using the Foreach Loop container to read all the files inside the specified folder.

How would you address these issues? What would your solution look like?