Geek Answers Handbook

Cannot use sensitive project option in SSIS 2012

In SSIS 2012, I am trying to use a project sensitive parameter to connect OLEDB to oracle. It works great with the Sensitive value set to FALSE (in Project Params Designer). But I do not want this password to be visible. As soon as I enable the Sensitive attribute in TRUE and try to execute my package, I get the following error:

Error: 0xC0017010 in the package: the expression will not be evaluated because it contains the sensitive parameter variable $ Project :: OracleConnectionString. Ensure that the expression is used correctly and that it protects confidential information.

Any advice would be appreciated!

Thanks, Vika

+4
source share
1 answer

I needed to remove the password from the connection string so that its Sensitive attribute was set to False. Then add an expression for the password. Set it, and then set its Sensitive attribute to True.

0
source

More articles:


All Articles