SSIS包布置后可以手动运行,设置了job却报错
0
SQL server 2012,系统是win2008R2.
参考了以前的贴子,梁勇老师说可以改数据源的密码,但是加了密码后,不能保存。请高手指点。
报错信息如下:
Message
Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 10:30:48 Error: 2013-12-20 10:30:48.73 Code: 0xC0016016 Source: dianbengjing Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "该项不适于在指定状态下使用。". 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: 2013-12-20 10:30:48.87 Code: 0xC0016016 Source: dianbengjing Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "该项不适于在指定状态下使用。". 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: 2013-12-20 10:30:49.16 Code: 0xC0202009 Source: dianbengjing Connection manager "kjdz.kjdz05" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80004005 Description: "ORA-01005: 给出空口令; 登录被拒绝". End Error Error: 2013-12-20 10:30:49.16 Code: 0xC020801C Source: dianbengjing_stage data from kjdz Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "kjdz.kjdz05" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2013-12-20 10:30:49.16 Code: 0xC0047017 Source: dianbengjing_stage SSIS.Pipeline Description: data from kjdz failed validation and returned error code 0xC020801C. End Error Error: 2013-12-20 10:30:49.16 Code: 0xC004700C Source: dianbengjing_stage SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2013-12-20 10:30:49.16 Code: 0xC0024107 Source: dianbengjing_stage Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:30:48 Finished: 10:30:49 Elapsed: 0.765 seconds. The package execution failed. The step failed.
参考了以前的贴子,梁勇老师说可以改数据源的密码,但是加了密码后,不能保存。请高手指点。
报错信息如下:
Message
Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 10:30:48 Error: 2013-12-20 10:30:48.73 Code: 0xC0016016 Source: dianbengjing Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "该项不适于在指定状态下使用。". 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: 2013-12-20 10:30:48.87 Code: 0xC0016016 Source: dianbengjing Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "该项不适于在指定状态下使用。". 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: 2013-12-20 10:30:49.16 Code: 0xC0202009 Source: dianbengjing Connection manager "kjdz.kjdz05" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80004005 Description: "ORA-01005: 给出空口令; 登录被拒绝". End Error Error: 2013-12-20 10:30:49.16 Code: 0xC020801C Source: dianbengjing_stage data from kjdz Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "kjdz.kjdz05" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2013-12-20 10:30:49.16 Code: 0xC0047017 Source: dianbengjing_stage SSIS.Pipeline Description: data from kjdz failed validation and returned error code 0xC020801C. End Error Error: 2013-12-20 10:30:49.16 Code: 0xC004700C Source: dianbengjing_stage SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2013-12-20 10:30:49.16 Code: 0xC0024107 Source: dianbengjing_stage Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:30:48 Finished: 10:30:49 Elapsed: 0.765 seconds. The package execution failed. The step failed.
没有找到相关结果
重要提示:提问者不能发表回复,可以通过评论与回答者沟通,沟通后可以通过编辑功能完善问题描述,以便后续其他人能够更容易理解问题.
7 个回复
BIWORK - 热衷于微软BI技术,技术架构和解决方案! 2013-12-20 回答
赞同来自: 梁勇 、天桥下的郑成功 、刚刚好 、yabei 、lco830
配置管理器中找到这两个账户
右键属性,然后将它们的启动账户都配置成管理员账户试试
halyan 2013-12-23 回答
赞同来自: yabei 、BIWORK 、xjb
另外,如果数据源是Oracle的话,别忘了发布Etl包的时候,要勾选“依靠服务器存储加密”
yabei - 大数据时代,谁也离不开BI 2013-12-30 回答
赞同来自: 梁勇 、BIWORK 、lco830
如下图,就解决问题了。
梁勇 - 天道酬勤、上善若水。爱好商业智能 2013-12-23 回答
赞同来自: yabei
您的一个简单点击,就可以帮助更多人。操作方法如下:
天桥下的郑成功 - Hadoop大数据开发工程师、数仓架构师、熟悉数据仓库设计、Hadoop、Spark、HBase、Hive、SSIS等开发 2013-12-23 回答
赞同来自: yabei
yabei - 大数据时代,谁也离不开BI 2013-12-20 回答
赞同来自:
我的数据源是远程服务器上的oracle。手动在SQL Server Agent 中能运行package, 在SSIS designer中也运行成功。我星期一再按你的方法试试。
yabei - 大数据时代,谁也离不开BI 2013-12-28 回答
赞同来自:
谢谢Halyan, 谢谢大家!
看起不是用户名的问题,但是依然非常感谢BIWORK 的答复。换了角度想问题
下周上班再发截图。
再次感谢各位!