September 7, 2009 at 5:39 am
I have an SSIS package which is running on a test server, querying databases on another server. There are 5 child packages in a parent package and whenever the job fails, returning the error below, it is on the same child package. Sometimes, the job runs fine when it is rerun straight afer failure.
Is there a known reason within SSIS as to why this would happen sporadically?
An OLE DB error has occurred. Error code: 0x80004005
OnError,SYSBOSIDEVTEST2,NT AUTHORITY\SYSTEM,CBS Data Flow Task,{3F929A6D-F693-4CB2-BAD2-D17FC0BC4127},{539694EE-3213-4E87-A168-93CD5EBA71D8},06/09/2009 07:38:03,06/09/2009 07:38:03,-1071636471,0x,SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Protocol error in TDS stream".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host.
".
November 6, 2009 at 5:53 am
I got the same error as well and its sporadic.. Have you found the solution yet?
December 16, 2013 at 6:28 am
I have also started encountering this problem. Would love to see a solution.
March 2, 2015 at 1:44 am
I have the same sporadic error when the etl-package creates a raw file on the server.
Is there nobody which have a solution for this error?
March 2, 2015 at 5:21 am
Last time I got this error - also quite randomly - I got it resolved by adding more memory to the server.
It seems a bit counter intuitive, but I did some research and it is possible that because of memory pressure an issue might occur when transfering data.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 2, 2015 at 6:06 am
Is there a possibility to find a logs or something else where i can find infos about the memory problem?
I need something which shows the reason
March 2, 2015 at 6:07 am
ArminJS (3/2/2015)
Is there a possibility to find a logs or something else where i can find infos about the memory problem?I need something which shows the reason
You can monitor the memory usage and if there is a peak at the moment where the error occurs...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply