Set a new plan parameter and value

Procedure

In the upper half of the Execution Plan page, double-click the plan for which you want to add parameters.
In the lower half of the Execution Plan page, click Parameters to display the corresponding view.
Example
Click Add on the toolbar to add a new line for the new parameter.
Click the Name cell and set the name for the new parameter.
Click the Value cell and set the value for this parameter.
The new plan parameter and value will display in the Plan parameter list in the task context parameter view, ready to be selected before the execution of the plan.

Information noteNote: When the context parameter is of type String, do not put its value between double quotes, unless if double quotes are needed in to the string value for further use.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!