CODEWITHSUNDEEP
sql-serversql-server-2005ssis

Reputation:

What does error 0xC02020C4 mean in SSIS?

I get this error with this description. 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.

Upvotes: 5

Views: 37896

Answers (4)

questionto42
questionto42

Reputation: 9562

I had the error when I pivoted data against a key that was not unique in the values. I had to aggregate the values to MIN(values) GROUP BY key before I could go on. Else, you would see:

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Pivot" (973) failed with error code 0xC02020CF while processing input "Pivot Default Input" (975). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.

The main hint was the last sentence There may be error messages posted before this with more information about the failure.. Right before the error message, you found:

[Pivot [973]] Error: Duplicate pivot key value "my_key".

Upvotes: 0

ShanksPranks
ShanksPranks

Reputation: 417

In my case this a misleading error, its a (multiple) source failure that is caused by a destination failure. I fixed / deleted the one destination that was failing and all the sources errors disappeared. This was a 14 tab excel book that I had as a source and one of the destinations had a type error but it was showing 8 or so sources failing with different amounts of rows transferred each run.

Upvotes: 0

Yoav24
Yoav24

Reputation: 363

This error may mean that you are loading too many rows at once for the buffer. In the Properties for the Data Flow Task, please try increasing the number for the DeafultBufferMaxRows. This solved this error for me.

Upvotes: 0

RBarryYoung
RBarryYoung

Reputation: 56735

I believe that the associated error message is "The attempt to add a row to the Data Flow task buffer failed with error code 0x{%errCode2}." Which should have been in a previous log message. Of course then you will want to get %errCode2, and translate it to an error message that should have been even earlier than that in the log messages. This could go back a ways.

The easiest approach is to turn all of the logging on, run it to the failure and the check the logs going backwards until you find the original generating exception.

Upvotes: 2

Related Questions