Post reply

Cannot use a sensitive project parameter on SSIS 2012

  • August 14, 2015 at 4:28 am

    #299770

    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

    #1819984

    Do not put the password in an expression.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • August 14, 2015 at 4:37 am

    #1819987

    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