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?

  • 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.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP