js
2005-12-14 20:33:07 UTC
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
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