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?

  • 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