ssis error

Question

SSIS failed with the below error when running in sql agent job.

Failed to decrypt protected XML node

The package is designed by my workmate but he has asked a sick leave, please help.

Answer 1

Hi @alwaysonhigh,

This behavior occurs when you try to run the SSIS package by using a different computer or a different user account than the computer and user account that were used to create the SSIS package.

To resolve this behavior, change the value of the ProtectionLevel property in the SSIS package.

More details you may refer the official documentations:

error-loading-message-run-integration-services-package

access-control-for-sensitive-data-in-packages

If the issue only occurs when you run the package via gent job, please consider to use proxy account which have the full permission to the file to run the job.

Reference: running-a-ssis-package-from-sql-server-agent-using-a-proxy-account

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

I guess EncryptionLevel of the package ist "ByUserKey" and sensible are encrypted only for the package creator.

You have to re-enter password etc.