This topic has not yet been rated - Rate this topic

Set Parameter Value Dialog Box

SQL Server 2012

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?

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.
In Object Explorer, expand the tree to display the Integration Services Catalogs node.
Expand the SSISDB node.
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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions