Using the global variable switch (/A) with dtsrun

[Andy]

We are running a DTS package with the dtsrun utility and would like to
pass a variable through it. Inside our package we have a VB script
that references a table that contains the information about all of our
jobs and we would like to pass a variable to tell it which jobs to
run. The reason we cannot just add the variable to the VB script,
i.e. in a where clause, is because we would like more then 1 bat file
to run this package. We want some jobs to run with 1 bat file and
other jobs to run with another. If we could pass through a variable
of 1 that would refer to a column within our table then only those
jobs would run at that time. Make sense?

Any help is appreciated

Thanks

[Simon Hayes]

dr*******@yahoo.com (Andy) wrote in message news:<70*************************@posting.google.c om>...

We are running a DTS package with the dtsrun utility and would like to
pass a variable through it. Inside our package we have a VB script
that references a table that contains the information about all of our
jobs and we would like to pass a variable to tell it which jobs to
run. The reason we cannot just add the variable to the VB script,
i.e. in a where clause, is because we would like more then 1 bat file
to run this package. We want some jobs to run with 1 bat file and
other jobs to run with another. If we could pass through a variable
of 1 that would refer to a column within our table then only those
jobs would run at that time. Make sense?

Any help is appreciated

Thanks

I don't completely understand what you're trying to achieve, but it
sounds like you want to pass a value to a command-line batch file
which runs DTSRUN.EXE, and have that value used in the DTS package as
a global variable. If so, then the easiest way is to use DTSRUNUI.EXE
to generate the package command line for you (click Advanced to get
the dialogue you need). You can then use standard batch substitution
(%1, %2 etc) in your batch file to set the values at runtime.

Simon