It seems like the only way to modify a (ODBC type) Connection Manager's password property is by creating and employing an XML Configuration file to which you can store, and from which you can retri...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_23198578.html