Prompted variables pass user input values into a source query or formula.
For example, a prompted variable can be used to load data from a certain date depending upon user input. When the DTS is opened or the job is run, the user is prompted to supply a date and the source query uses this value to retrieve the correct information. The source query has the variable name as part of its statement to use the value in this way.
Note: If quotation marks enclose the value passed in a prompted variable, the quotation marks are stripped from the variable. To pass a prompted variable with quotation marks, use escape characters (\") before each quotation mark. For example, to pass "Hello world" into a formula, use the following: "\"Hello world\""
Prompted variables can be used as values that are supplied either from within the Workbench or from command line arguments. Values supplied for prompted variables are not saved with the DTS.
Chained jobs are linked together so they run one after the other. Prompted Variable values are stored and used in subsequent jobs if the subsequent job is chained with the original job. In this situation, the chained job must be opened by doing one of the following in the Workbench:
You are prompted for a value again, but the value you entered originally is displayed in the entry window. You are not prompted when:
See Also
Running A Job From The Command Line