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

  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

Lists the parameter name.

Lists the data type of the parameter value.

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.