DTS_E_OLEDBERROR.错误代码:0x80004005.SQl本机客户端和sql Server的oledb提供程序之间的差异 [英] 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本机客户端10.0"结果:0x80004005 说明:通信链接失败".一个OLE DB记录是 可用的.来源:"Microsoft SQL Server本机客户端10.0" 结果:0x80004005描述:"TCP提供程序:指定的网络 名称不再可用.

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更改为SQL Server的Microsoft OLEDB Provider，希望它可以正常运行.这次出现错误，如下所示:

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记录是 可用的.来源:用于SQL Server的Microsoft OLE DB提供程序" 结果: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_OLEDBERROR.错误代码:0x80004005.SQl本机客户端和sql Server的oledb提供程序之间的差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！