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.Note: 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.