Export (0) Print
Expand All

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.

  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.

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.

Community Additions

ADD
Show:
© 2014 Microsoft