Set Parameter Value Dialog Box

Use the Set Parameter Value dialog box to set values for parameters and connection manager properties, for projects and packages.

What do you want to do?

  • Open the Set Parameter Value dialog box

  • Configure the options

Open the Set Parameter Value 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. Right-click a package or project, click Configure, and then click the ellipsis button in the Parameters tab or in the Connection Managers tab.

Configure the options

  • Parameter
    Lists the parameter name.

  • Type
    Lists the data type of the parameter value.

  • Description
    Shows an optional description for the parameter.

  • Edit value
    Select this option to edit the parameter value.

  • Use default value from package
    Select this option to use the default parameter value stored in the package.

  • Use environment variable
    Select this option to use a variable value stored in the environment, which is referenced by the project or package. To add an environment reference to a project or package, use the Configure dialog box. For more information, see Configure Dialog Box.