Hello, I am trying to use SSIS Script Task to get the current directly. I would like to know which directly the .dtsx file is located in.
The command line I use is:
dtexec.exe /file "\\MySever\Foo\Bar\myssis.dtsx"
I tried to use curdir(), but that gives me the directory that the dtexec.exe is being run from (i.e. c:\), which does not help. I really want my script task to return "\\MySever\Foo\Bar\myssis.dtsx" for me.
What can I do?
`Le