SSIS包升级
我有一个 SSIS 解决方案,其中包含在 SSIS 2005 中创建的 4 个包。当我在 SSIS 2008 中打开该解决方案时,它会显示 SSIS 升级向导。但升级失败。错误消息如下所示:
错误 0xc001405f:: 由于未指定密码或密码不正确,无法解密加密的 XML 节点。包加载将尝试在没有加密信息的情况下继续。
错误0xc001f429:程序包升级:程序包Package1.dtsx的加载失败
错误0xc0016016::无法解密受保护的内容XML 节点“DTS:密码”,错误为 0x8009000B“密钥在指定状态下使用无效。”。您可能无权访问此信息。当存在加密错误时会出现此错误。验证正确的密钥是否可用。
从 2005 年到 2008 年升级的正确步骤是什么?
I have a SSIS Solution with 4 packages created in SSIS 2005. When I opened the solution in SSIS 2008, it went for SSIS Upgrade wizard. But the upgradation had failed. The error messages are shown as follows :
Error 0xc001405f:: Failed to decrypt an encrypted XML node because the password was not specified or not correct. Package load will attempt to continue without the encrypted information.
Error 0xc001f429:Package Upgrade: The loading of the package Package1.dtsx has failed
Error 0xc0016016: : 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.
What is the correct step for upgradation from 2005 to 2008 ?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
VS 2008 不支持在 VS 2005 中开发的 SSIS 包。VS 2008 需要 SSIS 2008。有关更多详细信息,请查看以下链接
http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/a4c788cb-8461-4066-96a4-894dcb8de332/
SSIS packages developed in VS 2005 are not supported in VS 2008. VS 2008 need SSIS 2008. For more details check below link
http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/a4c788cb-8461-4066-96a4-894dcb8de332/
不确定它是否有帮助,但如果软件包是从另一台计算机移出的,也许您应该检查原始计算机的保护级别 http://support.microsoft.com/default.aspx?scid=kb;en-us;904800
Not sure if it helps, but if the packages were moved from a different machine, maybe you should check protection level at the original machine http://support.microsoft.com/default.aspx?scid=kb;en-us;904800