AMO DataSource ConnectionString Password and ConnectionStringSecurity

I am creating a datasource using AMO with the password embedded in the connectionstring to the database. After the datasource has been updated to the server, if I load it again, the password is removed from the connectionstring. I tried setting the ConnectionStringSecurity to "Unchanged" but it's reset back to "RemovePassword" when I load the datasource object again. Any ideas on how to avoid entering the password everytime?

This is not a bug in the product.
You are running into the situation when Analysis Server for security reasons strips any passwords from any responcse it sends to the users. Once you've told Analysis Server your password, it will keep it for internal usage only, it will never return it back to you. That is to reduce the risk of exposure: even if malitious user gains access to Analysis Server, it will not be able to learn your password.

It is true, in your situation you will need to work little harder in case and if you need to change data source using AMO.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.