Post reply

How to change the connection string of child packages in Execute Package task?

  • July 31, 2013 at 9:37 am

    #1637435

    .when we do config file at the master package environment, will the file pass the value to the child pacakges

    You wont need to create a config file for the master package, only the child packages. The master package should have variables, these will hold the values that you want to pass to the child packages. In the child packages, create variables there as well to catch the values that the parent package variables will pass to the child packages. Right click in the control flow area and select 'package configuration..' , then Add, then follow the wizard. The configuration type will be 'parent package variable.' This is where you map the values between the variables of the child and parent packages (make certain data types match). With this complete in your child package you are free to use your local variables in expressions (for ole db connection 'servername' property for example) as you normally do.

    ----------------------------------------------------

  • August 1, 2013 at 1:07 am

    #1637667

    mmartin1 (7/31/2013)

    You wont need to create a config file for the master package, only the child packages.

    Whilst that's true in the strictest sense, all but the simplest of packages should use config file (or some other external method of package configuration). That way, when you want to run the package on a different server or change the number of retries, for example, you just edit the configuration file instead of having to redeploy the whole solution.

    John

  • August 1, 2013 at 4:21 am

    #1637715

    Okay Martin...Let me try with config file for each child package...

  • August 1, 2013 at 4:24 am

    #1637717

    Whilst that's true in the strictest sense, all but the simplest of packages should use config file (or some other external method of package configuration). That way, when you want to run the package on a different server or change the number of retries, for example, you just edit the configuration file instead of having to redeploy the whole solution.

    I believe i got the idea of what you are saying. Let me try. Sorry that I took some time to make myslef clear.

Viewing 4 posts - 16 through 18 (of 18 total)

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