Home Forums SQL Server 2005 Business Intelligence How to change the connection strings of a child package? RE: How to change the connection strings of a child package?

  • November 13, 2013 at 7:06 am

    #1666062

    staudacher (11/13/2013)

    I think i missunderstood you, sorry.

    You will change the connection path from childtask.

    In the properties from ExecutionTask there is "Expression" where you can change the Connection with Expression builder (or make a file connection, set the ExecutionTask connection to file connection)

    Then change this connection before every call.

    Sorry Staud, i need to change the data source connection...not the file connection...

    what i did is, in the master package i created a variable called 'ConnectionString' and passed the value "Data Source=localhost;User ID=sa;Pwd=abc;Initial Catalog= databasename;Provider=SQLNCLI10.1;Integrated Security = SSPI;" and created a XML configration file....then i went to each of the child package and i created a variable with the same name under parent Package variable configuration and selected the connection string property....

    while executing, i changed the value of the variable in the config file of master package but it did not affect the child pacakge...it said ''Connection may not be configured correctly or you may not have the right permissions on this connection."

    I am not sure where i am making mistake....could you please help me?