We have had some serious head scratching with a very unhelpful error given on a SSIS package failure.
“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: “[DBNETLIB][ConnectionRead (recv()).]
General network error. Check your network documentation.”
The SSIS suite was in the 10th hour of a 15 hour data load (on a test server – not a production server) and this occurred. The previous evening gave a similar error, but at a different point in the evening and a different package.
Some clever investigation by our system/network guy found these two entries from MS support http://support.microsoft.com/kb/942861/en-us and http://support.microsoft.com/kb/951037, which talks about the specific network card we have. After switching off the ‘TCP Chimney Offload’, the SSIS load ran successfully.