August 14, 2015 at 4:28 am
Hi,
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 I have create 2 variables 1 for constring and another for password
$Project::constring = uid=whouse;Dsn=CANDM;
$Project::OraclepwdString=123
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::OraclepwdString". Verify that the expression is used properly and that it protects the sensitive information.
August 14, 2015 at 4:34 am
Do not put the password in an expression.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
August 14, 2015 at 4:37 am
Actually I want to pass the connection string from outside.
I have same package which will run for multiple location
i have 2 parameter 1 for constring and another for password
How to avoid visibility of password
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply