27,580
社区成员
发帖
与我相关
我的任务
分享SQL输出SSIS包报错
我做SQL2008的ssis包，输出EXCEL文件，然后SQL作业里调用，出错？
是否是我的本地用户权限不够，我设置用的是SA用户。
报错信息如下：
Executed as user: SCHNT-ERP\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 11:33:27 AM Error: 2018-09-13 11:33:28.70 Code: 0xC0202009 Source: new1131 Connection manager "SourceConnectionOLEDB" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D Description: "?? 'SA' ?????". End Error Error: 2018-09-13 11:33:28.72 Code: 0xC020801C Source: Data Flow Task 1 Source - Query [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" 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: 2018-09-13 11:33:28.72 Code: 0xC0047017 Source: Data Flow Task 1 SSIS.Pipeline Description: component "Source - Query" (1) failed validation and returned error code 0xC020801C. End Error Error: 2018-09-13 11:33:28.72 Code: 0xC004700C Source: Data Flow Task 1 SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2018-09-13 11:33:28.72 Code: 0xC0024107 Source: Data Flow Task 1 Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:33:27 AM Finished: 11:33:28 AM Elapsed: 1.653 seconds. The package execution failed. The step failed.
是否是我的本地用户权限不够，我设置用的是SA用户。
报错信息如下：
Executed as user: SCHNT-ERP\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 11:33:27 AM Error: 2018-09-13 11:33:28.70 Code: 0xC0202009 Source: new1131 Connection manager "SourceConnectionOLEDB" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D Description: "?? 'SA' ?????". End Error Error: 2018-09-13 11:33:28.72 Code: 0xC020801C Source: Data Flow Task 1 Source - Query [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" 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: 2018-09-13 11:33:28.72 Code: 0xC0047017 Source: Data Flow Task 1 SSIS.Pipeline Description: component "Source - Query" (1) failed validation and returned error code 0xC020801C. End Error Error: 2018-09-13 11:33:28.72 Code: 0xC004700C Source: Data Flow Task 1 SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2018-09-13 11:33:28.72 Code: 0xC0024107 Source: Data Flow Task 1 Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:33:27 AM Finished: 11:33:28 AM Elapsed: 1.653 seconds. The package execution failed. The step failed.
...全文
请发表友善的回复…
发表回复
吉普赛的歌 2018-10-24
- 打赏
- 举报
恭喜楼主， 
weixin_39755026 2018-10-24
- 打赏
- 举报
来人，我要结帖给分！！！！！！！！
weixin_39755026 2018-10-24
- 打赏
- 举报
确实是权限问题。需要本地读写权限和SQL权限都要有！
