Sunday, May 5, 2013

SSIS: Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED


Error:


[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on component "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.
 or
[OLE DB Destination [366]] Error: 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: "The statement has been terminated.".
An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80004005  Description: "Violation of PRIMARY KEY constraint

Solution and Explanation:

its similar to violation of Primary key constraint
This happens, when data in the same table with the same primary key or primary key combination , already exists. This may happen, when either u have not deleted the old records form the table 
or,
 when data in the same table is inserted from two sources ;say one through front end application , and another through scheduled job. In such cases , already some data remains in a table through say front end application , and at the same time, one scheduled job also tries to insert same data.

Please provide your feedback for the post, if you find this post useful. Also Post your query or scenario, i will be happy to help.

No comments:

Post a Comment