ssis error

alwaysonhigh 40 Reputation points
2023-08-30T13:36:18.6166667+00:00

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.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,226 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 25,301 Reputation points
    2023-08-31T01:28:10.17+00:00

    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.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 33,836 Reputation points
    2023-08-30T14:18:54.17+00:00

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

    You have to re-enter password etc.

    0 comments No comments