Cannot use a sensitive project parameter on SSIS 2012

6
votes

In SSIS 2012 I am trying to use a sensitive project parameter for an OLEDB connection for oracle. It works perfectly with with Sensitive value set to FALSE (in Project Params Designer). But I do not want 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

1
ssisssis-2012ssdt-bi
Try changing the package security protection level to EncryptSensitiveWithPassword and save the package and run. – Rao Y
How are you using $Project::OracleConnectionString? I assume that you are trying to assign it as an Expression on the Connection Manager, correct? If so, that's not the way to do with the 2012 Project Deployment Model – billinkc
@RaoY Thanks for reply. At present the protection level is set to DontSaveSensitive and I am sticking with that unless there is a valid reason to change. – Vick
@billinkc Yes that's right, my solution is in Project Deployment Model and I have parameterized the project connection for the connection string. – Vick
@billinkc what should be our approach for this in 2012 Project Deployment Model. Please suggest. Thanks! – Vick

1 Answers

2
votes

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.