Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Thursday, November 14, 2013 3:36 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 20, 2014 6:58 AM
Points: 138, Visits: 195
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