Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

How to change the connection strings of a child package? Expand / Collapse
Posted Thursday, November 14, 2013 3:36 AM


Group: General Forum Members
Last Login: Tuesday, December 16, 2014 6:32 AM
Points: 138, Visits: 197
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....
Post #1514204
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse