password reset related problem

how to reset passw开发者_C百科ord in every 3months in ssis package dynamically updated?how

1. You could store passwords in a XML configuration file. That would mean you would have to replace the XML configuration file through some script.
2. You could store the password in a database table. Not a good way to do it since anyone with access to the database could query it, but that could work.
3. You could eliminate the need for a password and use NT authentication if the service account doesn't change passwords, but that may not be possible in your situation.
4. You could store the passwords in an unencrypted manner locally and write a script to find and replace the password in the DTSX files and then script deploying the files. Again, storing the passwords in clear text may not be a good idea even though this approach is technically feasible.
5. You could override connection passwords in the SQL Server Agent job. One advantage of this approach is that you could easily script out the jobs and run a mass find/replace on the scripts.