SSIS 问题无法解密受保护的 XML 节点 [英] SSIS issue Failed to decrypt protected XML node

问题描述

我创建了一个 SSIS 包，它从 ftp 服务器中提取 ftp 文件并保存到我的本地驱动器，但我遇到了这个问题.

I created an SSIS package which is having ftp pull files from ftp server and save to my local drive but I'm getting this issue.

使用相同的错误消息，我只收到警告，但今天作业失败了.

With same error message I was getting only warning but today the job fails.

留言:

以用户身份执行:cam\Package.Runner.适用于 64 位的 Microsoft (R) SQL Server 执行包实用程序版本 10.0.4000.0 版权所有 (C) Microsoft Corp 1984-2005.版权所有.开始时间:上午 10:00:00 错误:2012-02-15 10:00:00.61 代码:0xC0016016 来源:描述:无法解密受保护的 XML 节点DTS:密码"，错误为 0x8009000B密钥在指定状态下无效.".您可能无权访问此信息.当存在加密错误时会发生此错误.验证正确的密钥是否可用.结束错误错误:2012-02-15 10:00:00.62 代码:0xC0016016 来源:描述:无法解密受保护的 XML 节点DTS:Property"，错误为 0x8009000B密钥在指定状态下无效.".您可能无权访问此信息.当存在加密错误时会发生此错误.验证正确的密钥是否可用.End Error 错误:2012-02-15 10:00:33.53 代码:0xC0029183 来源:Principal Balance File FTP Get FTP 任务描述:/Concerto/Virtus_Reports/Concerto Principal Balance Report*.pdf"表示的文件不存在.结束错误 DTExec:包执行返回 DTSER_FAILURE (1).开始:上午 10:00:00 结束:上午 10:00:33 经过:33.088 秒.包执行失败.步骤失败.

Executed as user: cam\Package.Runner. Microsoft (R) SQL Server Execute Package Utility Version 10.0.4000.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:00:00 AM Error: 2012-02-15 10:00:00.61 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2012-02-15 10:00:00.62 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Property" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2012-02-15 10:00:33.53 Code: 0xC0029183 Source: Principal Balance File FTP Get FTP Task Description: File represented by "/Concerto/Virtus_Reports/Concerto Principal Balance Report*.pdf" does not exist. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:00:00 AM Finished: 10:00:33 AM Elapsed: 33.088 seconds. The package execution failed. The step failed.

推荐答案

您可以通过设置保护级别属性来解决此问题

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.

这篇关于SSIS 问题无法解密受保护的 XML 节点的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！