Setting SSIS Connection Password?? URGENT!

[VTRCL1234]

Hi,

I have a show stopper problem.

I have an SSIS package that I'm running from a web page. I am trying to dynamically set the connection information, since production doesn't use the same settings as my desktop (duh!).

I've tried a bunch of different approaches. My latest was to try to set the connection string property of the connection object directly. Unfortunately, the Setter strips out the Password!

So this doesn't work:

Connections myConnections = ssisPkg.Connections;
myConnections["Config1"].ConnectionString = myConnectionString;

because the password is stripped out the string.

I've also tried Xml configuration, which seems to work okay in the VS environment, but when run programmaticly SSIS ignores the configuration.

Is there something I need to do to tell the package to *use* the configuration is knows about?

I can see configuration when I do this:

Configuration myConfigs = ssisPkg.Configurations;

I get a collection of configurations, including the one which has the password that I'd like to use, but SSIS just ignores it.

Any help is great appreciated as this has been 3 days of frustration.