Relative Paths in Task 'execute task'

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Relative Paths in Task 'execute task'

Add to briefcase

Relative Paths in Task 'execute task'

Expand / Collapse

Author

Message

Posted Wednesday, January 11, 2012 3:14 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, January 25, 2012 5:23 AM
Points: 6, Visits: 18

Hello,

what I mean with relative paths: I want to setup the WorkingDirectory or rather the variable "Executeable" so that the directory is set to the projectdirectory. I want a more dynamic path so that I don't have to change it whenever someone else on a different computer executes the SSIS package. Usually its enough to declare the path like this: "\application.exe", but apparently SSIS doesn't like that.

Thanks in advance.

EDIT: Sorry, I screwed up with the topic. I meant the task 'execute process' :)

Post #1233835

Posted Wednesday, January 11, 2012 9:05 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 3:07 PM
Points: 10,613, Visits: 11,959

Normally with SSIS you would do this using SSIS configurations or by setting a variable value using the command line options. Here are a couple of resources:

http://consultingblogs.emc.com/jamiethomson/archive/2007/03/13/SSIS_3A00_-Property-Paths-syntax.aspx
http://msdn.microsoft.com/en-us/library/cc895212.aspx

Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2

Post #1234079

Posted Thursday, January 12, 2012 4:03 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, January 25, 2012 5:23 AM
Points: 6, Visits: 18

Thank you. I'll take a look at it right away.

Post #1234634

« Prev Topic | Next Topic »

Add to briefcase

Permissions

Expand / Collapse