SSIS Execution Error


Failed to decrypt protected XML node DTS Password SSIS

when executing SSIS Package, the following error might occur.

Error
Source Description: 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 cryptographic error. Verify that the correct key is available.

Solution
In DTS Designer, it will not let you save the package with a protection level of server storage.

So
1. Select File -> Save Copy of as
2. The bottom grayed out box called Protection Level.click on the dotted button next to it and Dialog box will open.
3. Change the package protection level to "Rely on server storage and roles for access control"


Deploy the package after this change.This allows to execute the package defined by SQL server roles to run the package


Thanks
S.S.H.Abbas


Comments

No responses found. Be the first to comment...


  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: