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?

  • Koen Verbeeck (7/12/2013)


    You can create only one config file that stores for example the servername and the database. And you can pass this config file along when calling the child packages with DTEXEC.

    In this case you'll have to make a config file for each environment.

    Do we have to create config file while creating the master package? I am just curious ....if we have 5 child packages ...all those combined together forming a master package...when we do config file at the master package environment, will the file pass the value to the child pacakges? how does one package's variable affect the other?

    I am getting confused on this...Please bear with me, Koen...