The BI project note cannot decrypt a protected XML node "Dts:password" workaround

Original: BI project note failed to decrypt protected XML node "Dts:password" workaround

Description: Unable to decrypt the protected XML node "Dts:password", error 0x8009000b "This item is not suitable for use in a specified state. ”。 You may not have permission to access this information. This error occurs when there is a cryptographic error. Make sure that you provide the correct key.

Workaround:
1. In Integration Services, locate the package to execute, right-select the export package, select the exported path in the Export Package properties box, choose "Do not save sensitive data" on the protection level option.


2. Delete the package that has just been exported in Integration services, and re-import the exported package, again, set the protection level to "do not save sensitive data" in the Import Package properties box, and the above error will not occur if you execute the package again.

The BI project note cannot decrypt a protected XML node "Dts:password" workaround