Package running other packages

Hi everybody,

I have to create a package that executes other packages I've already created... Every one of these packages run with the same Configuration File, but if I try to execute the main one, including the path of the file, I get errors from the other packages because they can't find it... How can I manage to pass this file and its content to the other packages

Here a little explanation of te process:

Main Package needs configuration file X.dtsConfig, and calls: package1, which needs configuration file X.dtsConfig; package2, .......

I hope everything is clear...



Answer this question

Package running other packages

  • sortiz

    Restart the machine so the sys variable is recognized.
  • Todd Girvin

    I have completely replaced all these packages using config files and calling other packages.

    It it is supposed to work with SP1 though. I did not try sp1 yet.

    In the meantime, I have consolidated all these "sub-packages" functionality into the main packages.

    Philippe


  • SHAS3

    The people I work for decided I don't need to do this package anymore.... so I quit thinking about it.
    Thanks anyway!

  • mgreer

    I am stupid, and I need further explanations....

    I created a new environment variable, and I set its value with the path of my configuration file... is this the right thing to do

    After this I have enabled package configuration on the package, and set the source to that variable, but it doesn't work... Why

    Thanks


  • Elyahoo

    Why not just reference the same config file in each package

    This is made alot easier by the use of indirect configurations: http://blogs.conchango.com/jamiethomson/archive/2005/11/02/2342.aspx

    -Jamie



  • Silver

    but what I need is to pass the whole configuration file, not only some variable of the package.... how can I do that
  • Aaron128

    teone wrote:

    Hi everybody,

    I have to create a package that executes other packages I've already created... Every one of these packages run with the same Configuration File, but if I try to execute the main one, including the path of the file, I get errors from the other packages because they can't find it... How can I manage to pass this file and its content to the other packages

    Here a little explanation of te process:

    Main Package needs configuration file X.dtsConfig, and calls: package1, which needs configuration file X.dtsConfig; package2, .......

    I hope everything is clear...

    You can pass values from the parent package through to child packages using parent package configurations.

    -Jamie



  • jpmoreno

    teone wrote:

    I am stupid, and I need further explanations....

    I created a new environment variable, and I set its value with the path of my configuration file... is this the right thing to do

    Yes.

    teone wrote:

    After this I have enabled package configuration on the package, and set the source to that variable, but it doesn't work... Why

    Thanks

    Without being there its a bit hard to say. What "doesn't work" What behaviour are you expecting What happens instead

    -Jamie



  • Ron_S_MWA

    Bonus!!

    I wish my superiors would say that to me sometime! :)



  • Package running other packages