Is it possible to use expressions to change the connection string for the excel+ connection type?

[jimmy...@gmail.com]

I would like to use the excel+ connection and have it load a file on a monthly basis.  The file is located in a folder structure based on reporting period so I would need to change the connection string for the excel+ connection dynamically using expressions.  I gave it a shot and it doesn't seem to work so I'm curious if I'm missing something or if this is not supported.

Thank you

Jimmy

[Ivan Peev]

Hi Jimmy,

Right-click on the Excel+ Connection Manager and select Properties. Scroll-down and find RetainSameConnection property and set to FALSE. Now you should be able to change the Excel+ connection dynamically with expression.

Regards,

Ivan

[richard...@gmail.com]

Thanks.