Configure Dialog Box

  • Article

Use the Configure dialog box to configure parameters, connection managers, and references to environments, for packages and projects.

What do you want to do?

  • Open the Configure Dialog Box

  • Set the options on the Parameters page

  • Set the options on the References page

Open the 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.

Set the options on the Parameters page

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.

Set the options on the References page

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.