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

How to locate sub-packages dynamically? Expand / Collapse
Author
Message
Posted Wednesday, November 7, 2012 9:10 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 3:05 PM
Points: 1,191, Visits: 791
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?

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
Posted Thursday, November 8, 2012 4:10 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 3:05 PM
Points: 1,191, Visits: 791
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!


Cheers

Eric
Post #1382392
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse