encryption - SSIS XML 解密消息

Question

我的 SSIS 包说它成功了，但是当它运行时，它什么也没做(我可以看到)。

唯一错误的是这条消息(它不属于错误)。

描述:无法解密加密的 XML 节点，因为密码是
未指定或不正确。包加载将尝试在没有
加密信息

我的包上确实有密码，但是当我将包加载到 SSIS 时，我看不到任何地方可以输入密码。

我错过了一步吗？

Answer 1

此链接讨论此问题及其解决方案:
http://support.microsoft.com/kb/918760
这是该页面的摘要。有关详细信息，请参阅该页面。

To resolve this problem, use one of the following methods. The most appropriate method depends on the environment and the reason that the package failed. Reasons that the package may have failed are as follows:

The user account that is used to run the package under SQL Server Agent differs from the original package author. The user account does not have the required permissions to make connections or to access resources outside the SSIS package.

The package may not run in the following scenarios:

• The current user cannot decrypt secrets from the package. This scenario can occur if the current account or the execution account differs from the original package author, and the package's ProtectionLevel property setting does not let the current user decrypt secrets in the package.
• A SQL Server connection that uses integrated security fails because the current user does not have the required permissions.
• File access fails because the current user does not have the required permissions to write to the file share that the connection manager accesses. For example, this scenario can occur with text log providers that do not use a login and a password. This scenario can also occur with any task that depends on the file connection manager, such as a SSIS file system task.
• A registry-based SSIS package configuration uses the HKEY_CURRENT_USER registry keys. The HKEY_CURRENT_USER registry keys are user-specific.
• A task or a connection manager requires that the current user account has correct permissions.