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

Connection manager in SSIS - Expand / Collapse
Author
Message
Posted Tuesday, February 3, 2009 10:06 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, May 8, 2012 12:49 PM
Points: 339, Visits: 560
Hi there,

I have lots of SSIS pacakges where connection manager points to OLE DB connection. Now, I have new password for SQL server login.
Do I need to manually change password in all connection managers OR
Is there an easier way to do it?
I checked Properties of Connection manager.. but there isn't any variable for password. Though, it has system variables for Username, servername, ConnectionString etc..
Thanks!
Post #649049
Posted Tuesday, February 3, 2009 10:21 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 3:17 PM
Points: 1,118, Visits: 2,224
sql-oholic (2/3/2009)
Hi there,

I have lots of SSIS pacakges where connection manager points to OLE DB connection. Now, I have new password for SQL server login.
Do I need to manually change password in all connection managers OR
Is there an easier way to do it?
I checked Properties of Connection manager.. but there isn't any variable for password. Though, it has system variables for Username, servername, ConnectionString etc..
Thanks!


You have to apply your password from the configuration thru the ConnectionString property.


---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Post #649078
Posted Tuesday, February 3, 2009 10:55 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, May 8, 2012 12:49 PM
Points: 339, Visits: 560
Sorry to bother u again... but i didn't get it clearly.
Can you explain it a bit more ...
I assume it has to start with creating user variable...using it in ConnectionString .
I am not sure if this is right way
Or is there a web resource, I can refer to.
thank you!
Post #649118
Posted Tuesday, February 3, 2009 10:59 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 3:17 PM
Points: 1,118, Visits: 2,224
sql-oholic (2/3/2009)
Sorry to bother u again... but i didn't get it clearly.
Can you explain it a bit more ...
I assume it has to start with creating user variable...using it in ConnectionString .
I am not sure if this is right way
Or is there a web resource, I can refer to.
thank you!


You don't need to use variable and build the connection string. You can include the complete ConnectionString (with all parameters) in the configuration and apply it to the connection manager property.


---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Post #649124
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse