SSIS error

charmax001 60 Reputation points
2023-07-31T13:10:32.7166667+00:00

I try to use Dtexec.exe command to run the package, and then meet the error:

Failed to decrypt protected XML node "DTS:Password" with error

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

Accepted answer
  1. ZoeHui-MSFT 30,881 Reputation points
    2023-08-01T01:32:31.86+00:00

    Hi @charmax001,

    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

    Regards´╝î

    Zoe Hui


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

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Yitzhak Khabinsky 24,806 Reputation points
    2023-07-31T14:34:19.3733333+00:00

    Hi @charmax001,

    Just modify SSIS package/project setting ProtectionLevel value as DontSaveSensitive in Visual Studio.

    Please see below.

    SSIS - ProtectionLevel

    0 comments No comments