locked
Job Loads data successfully but also shows error : Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state." RRS feed

  • Question

  • Hi I have Job loading data in sql table. The package runs successfully and loads data but also shows error : Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.
    Friday, December 21, 2012 7:28 PM

Answers

  • You need to set the package protection type to "do not save sensative"

    Chuck Pedretti | Magenic – North Region | magenic.com


    • Edited by Chuck Pedretti Friday, December 21, 2012 7:57 PM
    • Marked as answer by JoJo_1 Friday, December 21, 2012 8:55 PM
    Friday, December 21, 2012 7:54 PM