DTS_E_OLEDB 错误.错误代码:0x80004005.SQL Native Client 和 oledb provider for sql server 的区别 [英] DTS_E_OLEDBERROR. Error code: 0x80004005.Difference between SQl Native client and oledb provider for sql server

问题描述

我在 SSIS 数据流组件中使用 SQL Server Native Client 10 时出现通信链接错误.

There was a communication link error while I was using SQL Server Native Client 10 in an SSIS Data Flow component.

错误:SSIS 错误代码 DTS_E_OLEDBERROR.OLE DB 错误有发生了.错误代码:0x80004005.OLE DB 记录可用.来源:Microsoft SQL Server Native Client 10.0"Hresult:0x80004005描述:通信链接失败".一条 OLE DB 记录是可用的.来源:Microsoft SQL Server Native Client 10.0"Hresult: 0x80004005 说明: "TCP Provider: 指定的网络名称不再可用.

Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Communication link failure".An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "TCP Provider: The specified network name is no longer available.

所以我从 SQL Server Native Client 10 更改为 Microsoft OLEDB Provider for SQL Server，希望它能正常运行.这次报错如下图:

So I changed from SQL Server Native Client 10 to Microsoft OLEDB Provider for SQL Server, hoping that it would run fine. This time got an error as shown below:

[Transacn_Tbl1[737]] 错误:SSIS 错误代码 DTS_E_OLEDBERROR.一个 OLE发生数据库错误.错误代码:0x80004005.OLE DB 记录是可用的.来源:Microsoft OLE DB Provider for SQL Server"Hresult:0x80004005 说明:SQL 上发生未指定的错误服务器.连接可能已被服务器终止.".

[Transacn_Tbl1[737]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "Unspecified error occurred on SQL Server. Connection may have been terminated by the server.".

[Transacn_Tbl1[737]] 错误:SSIS 错误代码DTS_E_INDUCEDTRANSFORMFAILUREONERROR.输入"OLE DB 目标输入(750)"失败，因为出现错误代码 0xC020907B，并且输入OLE DB 目标输入"(750) 上的错误行处置指定错误失败.指定对象发生错误指定的组件.之前可能有报错信息这是关于失败的更多信息.

[Transacn_Tbl1[737]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "OLE DB Destination Input" (750)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (750)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.

这两个提供商有什么区别?我应该使用哪个?

What is the difference between these 2 providers? Which one should I use?

推荐答案

看来您必须解决此问题，您必须更改 SQL Server 代理服务启动帐户的 Temp 目录的权限.向 SQL Server 代理代理帐户授予此目录的读取权限和写入权限.

It looks like you have to resolve this issue, you must change the permissions for the Temp directory of the SQL Server Agent Service startup account. Grant the Read permission and the Write permission to the SQL Server Agent proxy account for this directory.

http://support.microsoft.com/kb/933835

这篇关于DTS_E_OLEDB 错误.错误代码:0x80004005.SQL Native Client 和 oledb provider for sql server 的区别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！