SSIS error

Question

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

Answer 1

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.

Answer 2

Hi @charmax001,

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

Please see below.