Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

[How Do I] use SSIS to find the current Directory?

Status
Not open for further replies.

TheLe

Programmer
Aug 2, 2006
12
US

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


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top