In this article we will show you, How to apply SSIS Package Configuration using XML Configuration File stored in an environment variable with example. We already explained the list of Package Configurations in our previous article. So, please refer SSIS Package Configuration to understand the same.
This is very useful approach while we deploying the project. Because, you can save the configuration file at the client location, and create an environment variable point to that file. That’s all you have to do.
Before we start the package configuration, You have to create environment variable. We already explained the step by step approach to create an environment variable in our previous article. Please refer SSIS Package Configuration Using Environment Variable to understand the same.
In order to add new environment variable, please click on the Environment variables.. button.
Once you click on the Environment variables.. button, below shown window will be opened. Here you can see all the existing variables, and its values. Please click on the New.. button to add new variable.
As you can see we are adding Variable Name as ConfigurationPath, and Variable Value as C:\Users\Suresh\Documents\Visual Studio 2013\projects\PackageConfigurations\PackageConfigurations\ExecutepackageConfigFIle.dtsConfig. It means, we are creating an environment variable that contains the path of a XML configuration file. And the configuration file we are using is created in SSIS Package Configuration using XML Configuration File article
Click OK to close the Environment Variables window
SSIS Package Configuration using XML Configuration FIle Part 2
In order to add XML package configuration stored in an environment variable, right-click on the control flow region will open the context menu. Please select the Package Configurations.. option from the context menu
Once you select the Package Configurations.., a new window called Package Configurations Organizer is opened as we shown below. Please check mark the Enable Package Configurations to enable the configurations. Next, click on the Add button to add new configuration.
Clicking the Add button, will open a wizard. First page is the welcome wizard, please check mark Don’t shown this page again to avoid this page.
Select Configuration type: Here, we have to select the configuration type. By default XML configuration file is selected by the SSIS so, you don’t have to do anything.
We already explained about the Specify Configuration settings directly so Please refer SSIS Package Configuration using XML Configuration File article to understand the same. In this example we will explain about the Configuration location is stored in an environment variable. So, please select the same
As you can see, we are selecting the Configuration Path variable. Remember, if you don’t find the newly created variable, please close the projects, and reopen the BIDS.
Click the Next button
Let me rename the Configuration name as Connection String Configuration, and Click Finish button to close the wizard.
Now you can see our newly created Path configuration that holds the connection string information inside the Environment variable.
Let me run the package
Thank You for Visiting Our Blog