In a DTS, I would like to pass a global varible value "TestDdate" to a
Execute Process Task(win32 process)as a parameter, then the task call a batch
file which rename a file name to Testdate+2004.txt. Testdate is a gloable
variable, data format like 1019.


How can I achieve this?

Is it possible to set the paramenter of "Execute Process Task(win32 process)"
with the value get form package global variables?
I saw the task has a paramter input box, what is the format for me to put my
testdate there?

Thanks.

You can use the Dynamic Properties task to set the ProcessCommandLine
property of the Execute Process task. Parameters are just appended to
the end of the command being executed in the ProcessCommandLine
property. Whatever format is used for the parameters depends on what
you are calling.
If your goal is to just rename a file and use a global variable, you
can also use an AxtiveX script task and FileSystemObject to rename the
file. You can find an example of doing this at sqldts.com:
http://www.sqldts.com/default.aspx?292

-Sue

On Mon, 18 Oct 2004 17:25:02 -0700, Ann
<Ann (AT) discussions (DOT) microsoft.com> wrote:

Thank you. It's very helpful

"Ann" wrote: