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?

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