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.

  • 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.

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

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