Connection manager in SSIS -

• MuditGupta

  SSCrazy

  Points: 2596

  More actions

  February 3, 2009 at 10:06 am

  #128444

  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

  One Orange Chip

  Points: 28499

  More actions

  February 3, 2009 at 10:21 am

  #937328

  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

  SSCrazy

  Points: 2596

  More actions

  February 3, 2009 at 10:55 am

  #937362

  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

  One Orange Chip

  Points: 28499

  More actions

  February 3, 2009 at 10:59 am

  #937367

  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/