| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|---|
Lesson 5: Add SSIS package configurations for the Package Deployment Model |
Lesson 5: Add SSIS package configurations for the Package Deployment Model |
chugugrace |
chugu |
01/08/2019 |
sql |
integration-services |
tutorial |
[!INCLUDEsqlserver-ssis]
Package configurations let you set run-time properties and variables from outside the development environment. Configurations allow you to develop packages that are flexible and easy to both deploy and distribute. [!INCLUDEmsCoName] [!INCLUDEssISnoversion] offers the following configuration types:
-
XML configuration file
-
Environment variable
-
Registry entry
-
Parent package variable
-
[!INCLUDEssNoVersion] table
In this lesson, you modify the example [!INCLUDEssISnoversion] package that you created in Lesson 4: Add error flow redirection with SSIS to use the Package Deployment Model and take advantage of package configurations. You can also copy the completed Lesson 4 package included with this tutorial.
Using the Package Configuration Wizard, you create an XML configuration that updates the Directory property of the Foreach Loop container. You use a package-level variable mapped to the Directory property. After you create the configuration file, you modify the value of the variable from outside the development environment to a new sample data folder path. When you run the package again, the configuration file populates the value of the variable, and the variable in turn updates the Directory property. The package then iterates through the files in the new data folder, rather than in the original hard-coded folder.
Note
If you haven't already, see the Lesson 1 prerequisites.
This lesson contains the following tasks: