There was a communication link error while I was using SQL Server Native Client 10 in an SSIS Data Flow component.
当我在SSIS数据流组件中使用SQL Server本机客户端10时，出现了一个通信链接错误。
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.
错误:SSIS错误代码DTS_E_OLEDBERROR。发生了一个OLE DB错误。错误代码:0 x80004005。一个OLE DB记录是可用的。源:“Microsoft SQL Server Native Client 10.0”Hresult: 0x80004005描述:“Communication link failure”。一个OLE DB记录是可用的。源:"Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "TCP 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:
所以我从SQL Server Native Client 10改为Microsoft OLEDB Provider for SQL Server，希望它能正常运行。这一次出现如下所示的错误:
[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.".
错误:SSIS的错误代码DTS_E_OLEDBERROR。发生了一个OLE DB错误。错误代码:0 x80004005。一个OLE DB记录是可用的。源:“Microsoft OLE DB Provider for SQL Server”Hresult: 0x80004005 Description:“SQL Server上发生了未指定的错误”。连接可能已经被服务器终止。
[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.
[Transacn_Tbl1[737]错误:SSIS错误码DTS_E_INDUCEDTRANSFORMFAILUREONERROR。“输入”OLE DB目标输入”(750)“失败，因为发生了错误代码0xC020907B，而“输入”OLE DB目标输入”(750)上的错误行配置指定错误失败。在指定组件的指定对象上发生错误。在此之前可能有错误消息发布，并提供有关失败的更多信息。
What is the difference between these 2 providers? Which one should I use?
这两个提供者的区别是什么?我应该用哪个?
1 个解决方案
#1
0
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.
看起来您必须解决这个问题，您必须更改sqlserver代理服务启动帐户的临时目录的权限。将读权限和写权限授予此目录的SQL Server代理代理帐户。
http://support.microsoft.com/kb/933835
http://support.microsoft.com/kb/933835
#1
0
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.
看起来您必须解决这个问题，您必须更改sqlserver代理服务启动帐户的临时目录的权限。将读权限和写权限授予此目录的SQL Server代理代理帐户。
http://support.microsoft.com/kb/933835
http://support.microsoft.com/kb/933835