Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Connection manager in SSIS -


Connection manager in SSIS -

Author
Message
MuditGupta
MuditGupta
Old Hand
Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)

Group: General Forum Members
Points: 361 Visits: 580
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!
CozyRoc
CozyRoc
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1492 Visits: 2235
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/


MuditGupta
MuditGupta
Old Hand
Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)Old Hand (361 reputation)

Group: General Forum Members
Points: 361 Visits: 580
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!
CozyRoc
CozyRoc
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1492 Visits: 2235
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/


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search