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!