Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Relative Paths in Task 'execute task' Expand / Collapse
Author
Message
Posted Wednesday, January 11, 2012 3:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, July 24, 2014 9:07 AM
Points: 11,157, Visits: 12,899
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

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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