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..