SSIS issue Failed to decrypt protected XML node

While importing the package to SQL Server choose Protection Level: Either

1- Don't save sensitive data.

2- Rely on Server Storage and roles for access control.

Screenshot from SSIS Project Package Properties:

enter image description here

You can fix this issue by setting the Protection Level property

Protection Level : DontSaveSensitive

With this property, the package will not be password protected, and another server can access and execute any job with other credentials.

Related