SSIS database connection passwords lost on deployment

[johnv20]

Hi,
I've got an issue when creating SSIS packages where the connection password for any database connection is being lost when the package is deployed to a database.

Doing a google search on this I have found references to add the password information to the package xml file, however I cannot find any examples or tutorials on how to do this.

Does anybody have an idea on how to do this ?

Thanks

 

[macleod1021]

http://msdn2.microsoft.com/de-de/library/ms136093.aspx

Check that page out for a good walk-thru on using the ConnectionManager Class.

 

[johnv20]

sorry - I should have mentioned that I'm building the packages using BIDS

Due to the complexity & number of packages that I need to build I would prefer not to have to code every one individually