How to locate sub-packages dynamically?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » How to locate sub-packages dynamically?

How to locate sub-packages dynamically?

Rate Topic

Display Mode

Topic Options

Author

Message

Eric Mamet

Posted Wednesday, November 07, 2012 9:10 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 10, 2013 2:41 AM
Points: 1,129, Visits: 685

Hi there,

I have a master package calling sub-packages.
All my packages are deployed in one folder on the file system.

How can I configure my master package so that it calls its sub-packages within the same folder as itself? Cool

I am trying to avoid any configuration variable, etc...
I suppose it could be done by setting up the child packages file connection values through an expression but I don't know how to get my master package initial folder?

Any suggestions?

Thanks

Eric

Post #1382044

Eric Mamet

Posted Thursday, November 08, 2012 4:10 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 10, 2013 2:41 AM
Points: 1,129, Visits: 685

Well... Here is what I did if anyone is interested...

I stored the location of SSIS Packages at Runtime in some database table and used an Expression to change the value of the File Connection used in the Execute Package task.

I would have liked to get the master package current location on the fly, hence avoiding one more configuration data, but it's not a big deal.
Having said that, if you know how to do that, I am still interested! BigGrin

Cheers

Eric

Post #1382392

« Prev Topic | Next Topic »

Permissions