DTS Execute Process Taks Question

#1

In the properties sheet for a DTS Execute Process Task, there is a input box
for 'Parameters' which allow you to add command-line options to the task exe
specified. How can you use the DTS Global variables to be passed in this
parameter field? Is there a special format to indicate that the parameters
are in fact global variable tokens?

#2

Here is one way of doing things

How to manipulate the Execute Process task.
(http://www.sqldts.com/default.aspx?251)

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Count Darling" <cdarling (AT) budgetext (DOT) com> wrote

Quote:

In the properties sheet for a DTS Execute Process Task, there is a input
box
for 'Parameters' which allow you to add command-line options to the task
exe
specified. How can you use the DTS Global variables to be passed in this
parameter field? Is there a special format to indicate that the parameters
are in fact global variable tokens?

#3

Have you had a look at possibly using a ActiveX Script
with the shell command?

Quote:

-----Original Message-----
In the properties sheet for a DTS Execute Process Task,
there is a input box
for 'Parameters' which allow you to add command-line
options to the task exe
specified. How can you use the DTS Global variables to be
passed in this
parameter field? Is there a special format to indicate
that the parameters
are in fact global variable tokens?

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS Execute Process Taks Question

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS Execute Process Taks Question - 07-02-2004 , 08:44 AM

Re: DTS Execute Process Taks Question - 07-02-2004 , 09:42 AM

DTS Execute Process Taks Question - 07-02-2004 , 09:46 AM