...
Step 1 | Create a SQL task called SQL with Variable with the following SQL command:
| ||||
---|---|---|---|---|---|
Step 2 | Click the Save button and then re-open the task. | ||||
Step 3 | Click the Variables tab and create a Variable with the following values:
| ||||
Step 4 | Click the Save button and in the task Details, click the Update button. | ||||
Step 4 | Create a Workflow called Variable Workflow. | ||||
Step 5 | Add the SQL With Variable task to the Workflow and save it. | ||||
Step 6 | Launch Variable Workflow. and open the SQL With Variable task instance on the Activity Monitor. Note that the SQL command resembles the following, with the value from the task variable.
| ||||
Step 7 | Open the task and delete the task variable. | ||||
Step 8 | Go back to Variable Workflow and add the following variable:
| ||||
Step 9 | Open the task instance. The SQL command used the variable from the workflow because the task no longer had a variable.
| ||||
For additional information, see:
...