sql server dts: SSIS Execute Process Task Variables -- sql server dts

SSIS Execute Process Task Variables

js
12/14/2005 12:33:07 PM

sql server dts: I have a need to pass an argument to an executable in an SSIS package. The
value of the argument is not static, it will vary at execution time, so I
need to pass the value of an SSIS variable as the argument to the exe in the
Execute Process Task

As an example I can define my executable as "C:\Windows\Notepad.exe". I
want my argument to be the value stored in the variable User::Source. I've
tried different methods to pass this such as "@[User::Source]" which should
evaluate to "C:\temp\input.txt", but no matter what I do it always passes the
literal value such as "@[User::Source]"

This seems a simple thing so I expect I'm just missing something. Can
anyone point out what I need to do to make this work?

Thanks

js

RE: SSIS Execute Process Task Variables

js
12/14/2005 4:24:53 PM

Problem solved. Sure enough, publicly proclaim your ignorance (mine
actually) and the answer will come...

For my example below I don't have to put anything in the "Arguments"
property. What I needed to do was put "User::Source" in the
"StandardInputVariable" property (which I had tried) and leave the arguments
property blank (which I hadn't tried). I'm guessing the arguments property
is for command line switches of constant value such as "/F". I can state
with certainty that it isn't for parameter values.

Thanks,

js

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.