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 14, 2013 at 3:36 am

    #1666313

    staudacher (11/13/2013)

    In my Parent/Child configuration i had trouble with "each child package and i selected the connectionmanager property's connection string" and changed it to "link the StringParentVariable to the StringChildVariable then use ChildVariable as Expression to the Connection"

    But if the direct way works well for you, its better then my detour

    Hi Staud, It worked finally...the problem was that i declared the value to the connection variable with "Integrated Security = SSPI"...After taking this, it worked...

    Thank you so much for your kindly help staud...actually, i tried to implement this two years back..but i was not able to understand...Now i got it with all your help..Thanks again...I appreciate your help....