Configure Dialog Box

1. In SQL Server Management Studio, connect to the Integration Services server.

   You’re connecting to the instance of the SQL Server Database Engine that hosts the SSISDB database.

2. In Object Explorer, expand the tree to display the Integration Services Catalogs node.

3. Expand the SSISDB node.

4. Expand the folder that contains the package or project that you want to configure.

5. Right-click the package or project, and then click Configure.

Use the Parameters page to view parameter names and values, and to modify the values.

Select the scope of the parameters displayed in the Parameters and Connection Managers tabs, in the Scope drop-down list.

The following is a list of the options in the Parameters tab.

Container

Lists the object that contains the parameter.

Name

Lists the parameter name.

Value

Lists the parameter value. Click the ellipsis button to change the value in the Set Parameter Value dialog box.

The following is a list of the options in the Connection Managers tab. You use this tab to change values for connection manager properties. Parameters are automatically generated on the SSIS server for the properties.

Container

Lists the object that contains the connection manager.

Name

Lists the connection manager name.

Property name

Lists the name of the connection manager property.

Value

Lists the value assigned to the connection manager property. Click the ellipsis button to change the value in the Set Parameter Value dialog box. You can enter a literal value, map an environment variable that contains the value you want to use, or use the default value from the package.

Use the References page to add and remove references to environments, and to access environment properties.

An environment specifies runtime values for packages contained in the projects you’ve deployed to Integration Services server.

Environment

Lists the environment.

Environment Folder

Lists the folder that contains the environment.

Open

Click to open the Environment Properties dialog box.

Add

Click to add a reference to an environment. In the Browse Environments dialog box click an environment and then click OK.

You can select an environment contained in any project folder under the SSISDB node.

Remove

Click an environment listed in the References area, and then click Remove.