Post reply

How to locate sub-packages dynamically?

  • November 7, 2012 at 9:10 am

    #265175

    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

  • November 8, 2012 at 4:10 am

    #1557094

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply