Environment Properties Dialog Box

An Integration Services environment stores zero or more variables. Each environment variable can be used to bind values to parameters at the time of package execution. Use environments to organize parameter values for different scenarios. For example, an environment that is named “Test” could provide values to your package before it is executed against a group of production servers.

For a description of how to create a new environment, see Create a Server Environment.

  1. On the Variables page of the Environment Properties dialog box, click the Name column in an empty row and enter a name for the environment variable, or select an existing variable. The name of the variable does not need to match the name of the project parameter that you will map to the variable.

  2. Select the Type for the variable. The type of the environment variable must match the type of the project parameter that you will map to the variable.

  3. Enter an optional Description for the variable.

  4. Enter the Value for the environment variable.

  5. Indicate whether the variable is Sensitive.

  1. Right-click the package in SQL Server Management Studio and select Configure....

  2. On the References page, click Add..., select the environment, and click OK.

  3. On the Parameters page, click the ellipsis button (...) for the project parameter.

  4. Select Use environment variable and select the environment variable you want to map to the project parameter. Note that only variables that match the type of the parameter are displayed in the list. Click OK and then OK again to close the Configure dialog box.

When you set the environment variable before executing the package, the variable sets the value of the associated project parameter.