Sql – Random SSIS Error Code DTS_E_PRIMEOUTPUTFAILED

sqlsql serverssis

I've seen many posts about this error, the difference is that i'm having this error some days yes, some days no and I can't establish a relation to anything. If I re-run the SSIS package inmediatly after the error it usually works ok.

I've changed the sql driver, as I saw on many posts related to this error, but it doesn't work.

So… this is the case: each time the SSIS package fails I'm having 2 error messages

Error1: -1073450952: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "XXXX" (30) returned error code
0xC0202009. 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. There may be error messages posted before this
with more information about the failure.

Error2: -1071636471: 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: "Protocol error in TDS stream". An
OLE DB record is available. Source: "Microsoft SQL Server Native
Client 10.0" Hresult: 0x80004005 Description: "Communication link
failure". An OLE DB record is available. Source: "Microsoft SQL
Server Native Client 10.0" Hresult: 0x80004005 Description: "TCP
Provider: An existing connection was forcibly closed by the remote
host. ".

An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Communication link failure".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host.
".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Communication link failure".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host.
".

Thanks in advance for your time and help!

Best Answer

This sort of issue is fairly common and practically impossible to track down and eliminate.

I would initiate the SSIS Package from a SQL Server Agent Job. In the Job Step definition I would set it to retry e.g. 3 times with a 5 minute delay.

Related Topic