Relative Paths in Task 'execute task'

• z1pp

  SSC Veteran

  Points: 284

  More actions

  January 11, 2012 at 3:14 am

  #248830

  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'

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  January 11, 2012 at 9:05 am

  #1431875

  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
  Consultant - Straight Path Solutions
  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

• z1pp

  SSC Veteran

  Points: 284

  More actions

  January 12, 2012 at 4:03 am

  #1432343

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