Geek Answers Handbook

DTS_E_OLEDBERROR. Error Code: 0x80004005. Difference between SQl Native client and oledb provider for sql server

There was a communication error when I used SQL Server Native Client 10 in the SSIS data flow component.

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 error." OLE DB record available. Source: "Microsoft SQL Server 10.0 Primary Client" Hresult: 0x80004005 Description: "TCP provider: the specified network name is no longer available.

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

[Transacn_Tbl1 [737]] Error: SSIS error code DTS_E_OLEDBERROR. OLE DB Error. Error Code: 0x80004005. OLE DB record available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "A faulty error occurred in the SQL Server. The connection may be terminated by the server.".

[Transacn_Tbl1 [737]] Error: SSIS error code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. "OLE DB Destination" input "Input error" (750) "because error code 0xC020907B occurred, and the location of the error line at the input" OLE DB destination input "(750)" indicates an error during the error. An error occurred on the specified object of the specified component. Error messages may be sent earlier with additional information about the failure.

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

+6
source share
1 answer

It looks like you need to solve this problem, you must change the permissions for the Temp directory of the SQL Server Agent Agent startup account. Grant read permission and write permission to the SQL Server Agent proxy account for this directory.

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

0
source

More articles:


All Articles