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 11, 2013 at 2:44 pm

    #1631747

    prakashr.r7 (7/11/2013)

    Koen Verbeeck (7/11/2013)

    Normally I create package configurations for each package.

    Is there something special about your set-up that prevents this?

    Sorry Koen, nothing special... so we have to add all the package configurations and run with the master package ...? I was thinking that how the master EXECUI would accept these config files..? That's why i came here for clarification.

    DTEXECUI is the graphical version of DTEXEc, you cannot use this in a package. You can call however DTEXEC to execute a specific package and specify a configuration file as a parameter. Maybe that is the direction that you want to pursue?

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