Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Protocol error in TDS stream - sporadic error Expand / Collapse
Author
Message
Posted Monday, September 7, 2009 5:39 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, February 7, 2011 4:56 AM
Points: 30, Visits: 83
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.
".
Post #783721
Posted Friday, November 6, 2009 5:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 4:38 AM
Points: 3, Visits: 170
I got the same error as well and its sporadic.. Have you found the solution yet?
Post #814876
Posted Monday, December 16, 2013 6:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 12:14 PM
Points: 1, Visits: 20
I have also started encountering this problem. Would love to see a solution.
Post #1523185
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse