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:31 am

    #1666080

    staudacher (11/13/2013)

    Okay, my first attempting is right.

    In the Parentpackage you have the Variable ConnectionString.

    Make the same Variable in each ChildPackage

    Then in the CildPackages, instead to point to XML, choose ParentPackageVariabel, link the PackageVariable to ChildVariable and then add ChildVariable to the ConnectionString.

    Or try to resove the Error with XML, then it should work to, maybe the path is wrong or permission denied or any else

    Yes Staud...that's what i am doing....i did not create XML file for child package..i created it for master pacakge and exactly as like as you told, i created parent variable package config for each child package and i selected the connectionmanager property's connection string...

    but i am not understanding this line

    link the PackageVariable to ChildVariable and then add ChildVariable to the ConnectionString.

    can you tell me please?