Post reply

Unable to map an environment variable with the sensitive property set to True

  • December 13, 2016 at 9:04 am

    #316780

    Hi,

    I am getting the error below from the SSIS package scheduled from a SQL agent job . Locally the package works fine.

    Description: Unable to map an environment variable with the sensitive property set to True, to a parameter with the sensitive property set to False. Ensure that the property settings match. Source: .Net SqlClient Data Provider Started: 3:59:16 PM Finished: 3:59:16 PM Elapsed: 0.297 seconds. The package execution failed. The step failed.

    Please help.

    Thanks,

    PSB

  • December 13, 2016 at 9:08 am

    #1917655

    PSB (12/13/2016)

    Hi,

    I am getting the error below from the SSIS package scheduled from a SQL agent job . Locally the package works fine.

    Description: Unable to map an environment variable with the sensitive property set to True, to a parameter with the sensitive property set to False. Ensure that the property settings match. Source: .Net SqlClient Data Provider Started: 3:59:16 PM Finished: 3:59:16 PM Elapsed: 0.297 seconds. The package execution failed. The step failed.

    Please help.

    Thanks,

    PSB

    The message correctly identified your problem. If by 'locally' you mean when running via SSDT, note that SSDT does not pick up environment references.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • December 13, 2016 at 9:16 am

    #1917659

    Not sure what I need to fix and where in environment variables. Can you please elaborate ?

  • December 13, 2016 at 10:26 am

    #1917686

    PSB (12/13/2016)

    Not sure what I need to fix and where in environment variables. Can you please elaborate ?

    Change the 'Sensitive' property of either the environment variable or of the package parameter so that it matches the other.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply