Home Forums SQL Server 2005 Business Intelligence How to change the connection string of child packages in Execute Package task? RE: How to change the connection string of child packages in Execute Package task?

  • July 15, 2013 at 10:15 am

    #1632555

    John Mitchell-245523 (7/12/2013)

    prakashr.r7 (7/12/2013)

    Sorry John, I am not getting you...Could you please make me clear?

    Check this out. You can then use the variable to set the ConnectionString property of your connection manger in the child package.

    John

    Okay John..How do we change the connection string for the child packages.... we create config files for each package....when i use Execute Package task to create a master package , i don't see any way (i may not know) to change the connection string even running through BIDS....so if we create config file, how does this file will affect all the child package connection string? Why i am asking this because, child packages are created by different project...i create new project for master package...so how does these two packages connect with each other through config files?