none
SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.

    Question

  • Hi,

    I have a simple data flow where data is read from a OLEDB source and written onto a OLEDB destination. The source has a SQL command that reads two columns and maps to a table. when I run the component, 9362 rows of data is transferred and the source and destination components remain yellow for ages. 

    The output has the following error.


    SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC02020C4.  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.

    Any ideas

    Thanks
    Wednesday, September 23, 2009 9:35 AM

All replies

  • Hi,

    Can you post the full error messages. generally you get four to five lines of error messages in BIDS.

    Regards,
    Raju
    Wednesday, September 23, 2009 9:42 AM
  • Hi,

    The list of full error messages is

    Error: 0xC00470E4 at Data Flow Task, DTS.Pipeline: The pipeline received a request to cancel and is shutting down.
    Error: 0xC02020C4 at Data Flow Task, OLE DB Source [1]: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.
    Error: 0xC0047038 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC02020C4.  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.
    Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED.  Thread "SourceThread0" has exited with error code 0xC0047038.  There may be error messages posted before this with more information on why the thread has exited.
    The program '[4068] Package2.dtsx: DTS' has exited with code 0 (0x0).


    Apart from mapping two columns, I am adding a Surrogate Key to the table which is just an identity column which increments by 1.

    Thanks
    Wednesday, September 23, 2009 9:45 AM
  • Hi,

    Resolved it. Just changed the defaultbuffernaxrows property to 100000 from 10000 and it worked.

    Thanks
    Wednesday, September 23, 2009 10:27 AM
  • That probably won't solve your issue - it seems like a band-aid on it.  Were there any other warnings or errors before the "pipeline received a requeust to cancel" message?  That message generally indicates that there was an error in a component, causing SSIS to terminate the flow.
    Todd McDermid's Blog
    Wednesday, September 23, 2009 3:37 PM
    Moderator