Cannot use a sensitive project parameter on SSIS 2012

Question

In SSIS 2012 I am trying to use a sensitive project parameter for an OLEDB connection for oracle. It works perfectly with the Sensitive property set to FALSE (in Project Params Designer). But I do not want the password to be visible like that. As soon as, I turn the Sensitive attribute to TRUE and try to execute my package, I get the following error:

Error: 0xC0017010 at Package: The expression will not be evaluated because it contains sensitive parameter variable "$Project::OracleConnectionString". Verify that the expression is used properly and that it protects the sensitive information.

Any advice would be appreciated!

Thanks, Vick

Answer 1

What I had to do was remove the password from the connection string, leave its Sensitive attribute set to False. Then add an expression for the Password. Set it and then set its Sensitive attribute to True.