title: Random SSIS Error Code DTS_E_PRIMEOUTPUTFAILED
body: <p>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. </p>
  
  <p>I've changed the sql driver, as I saw on many posts related to this error, but it doesn't work.</p>
  
  <p>So... this is the case: each time the SSIS package fails I'm having 2 error messages</p>
  
  <blockquote>
    <p><strong>Error1</strong>: -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.</p>
    
    <p><strong>Error2</strong>: -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. ".</p>
  </blockquote>
  
  <p>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.
  ".</p>
  
  <p>Thanks in advance for your time and help!</p>