You can use prompted
variables with Next Job to force the user to pass values, such as
a password, into a source query.
To use the Next Job tab with prompted variables
If run from the command line using the /rs switch,
all prompted variables must be supplied as parameters for all jobs in
the chain.
The parameters are stored in memory and are available to all jobs in the
chain. If any job in the chain has Prompted variables that are not provided
on the command line, that job uses the default values provided when the
Prompted variable was created.
You must
know all Prompted variables in the chain, and must supply them all on
the command line.
Chained jobs are linked together so they run one after the other.
If you do not use /rs,
or if the initial DTS is opened from within Workbench, you are
initially prompted for variables for the first job only. When the job
is run, you will be asked if processing should pause between jobs to allow
you to cancel remaining jobs and to view job results.
If you choose to pause between jobs, you will be prompted
for the Prompted variables in the next opened job if they were not supplied
in the previous job(s).
Note: All chained
DTS files must be stored in the same directory.
If the current job ends in a fatal error, the next job will not execute.