Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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.

What do you want to do?

  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.


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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft