SSIS Relative File Path for referencing .dtsx files on a execute package task

Hi I have an SSIS package in which i have a main package that references child packages, is there a way I can make the location path external using a Relative path or just the file name. I cant use the full C: drive path as this is subject to change.

Answers


yes, but you have to find a way of changing the current working directory of the execution of the package. I worked at one place where we ran bat files to execute the packages and the first line used cd to set the working directory to the folder location of the parent package. I think I've also seen people use a script task inside the parent package to set the working directory based on the runtime location of the parent package.

http://www.artisconsulting.com/blogs/greggalloway/2008/7/13/relative-paths-in-ssis


from what i found it is best to use the project reference system instead of file reference and you can reference any project file if you deploy to the SSISDB instead of the MSDB, it works much better than the MSDB as well as being able to work with package params easier


Need Your Help

SQLAlchemy multiple foreign keys in one mapped class to the same primary key

python postgresql sqlalchemy

Am trying to setup a postgresql table that has two foreign keys that point to the same primary key in another table.

How to get notified about changes on SharePoint groups.

events sharepoint event-handling moss

I'm actual looking for a way to get notified about any changes on a SharePoint group. First I though I would be able to this by attaching a event handler to some kind of group list. But unfortunately