Hi,

I need to update the properties of analysis services connection manager
dynamically. Currently I have an SQL task whichs sets variables. One of these
variables is connection string:

i.e.

Data Source=SSDT-DSS1\DSSDVT;Initial Catalog=Finance
Miscellaneous-FINDVT;Provider=MSOLAP.3;Impersonation Level=Impersonate;

I created a connection manager and in expressions set connectionstring equal
to my connection string variable.

i.e.
connectionstring = (@[User::connection_string])

For some reason, when I try and execute the package it doesn't seem to
evaluate the connection string which is set. When I switch on the debug
watch the values for variable looks okay but the analysis services processing
task doesn't seem to pick the changes to the connection string.

Does anybody got any good examples for trying to build the properties of the
connection manager from variables?

Note: I have retainsameconnection set to false,

Thanks
Mick Anderson