Hi Guys,
I'm using Native OLE DB\SQL Native Client provider to get data from SQL Server 2000 database into SQL Server 2005 database using SSIS.
The problem is I get this error:
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: "[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.".
The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the
component, but the error is fatal and the pipeline stopped executing.
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q229/5/64.asp&NoWebContent=1
It may have to do with connection pooling, evidently they will not work well in OLE DB
No comments:
Post a Comment