7

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

Hadi
  • 36,233
  • 13
  • 65
  • 124
Vick
  • 71
  • 1
  • 2
  • Try changing the package security protection level to **EncryptSensitiveWithPassword** and save the package and run. – Rao Y Feb 05 '15 at 07:42
  • 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 Feb 05 '15 at 16:34
  • @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 Feb 09 '15 at 09:28
  • @billinkc Yes that's right, my solution is in Project Deployment Model and I have parameterized the project connection for the connection string. – Vick Feb 09 '15 at 09:47
  • @billinkc what should be our approach for this in 2012 Project Deployment Model. Please suggest. Thanks! – Vick Feb 09 '15 at 09:56
  • @Vick are you still looking for an answer? – Shiva Jun 12 '16 at 22:53
  • @billinkc, you said that assigning ConnectionString parameters to Connection Manager as expressions is not the way to do it in SSIS 2012. What's the recommended way then? Vick, did you find an answer? I'm having the same issue – Cesar Vinas Sep 09 '16 at 01:17

1 Answers1

3

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.

PBMe_HikeIt
  • 659
  • 8
  • 24