SSIS Error Code 0xC020209C & SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.

I encountered the above error when attempting to load a data file which contained the pipe character “|” as the delimiter when the tab character “\t” was expected.

This error message occurred when the two following error codes were encountered together:

  • Code: 0xC020209C
    Description: The column data for column “COLUMN NO 1” overflowed the disk I/O
  • Code: 0xC0047038
    Description: Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component “Flat File Source” (1) returned error code 0xC0202091. 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.

————————————————–
COLUMN DELIMITER WAS INCORRECT (“|”)
————————————————–

Microsoft (R) SQL Server Execute Package Utility
Version 10.0.2531.0 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started: 11:52:03 AM
Error: 2010-08-10 11:52:33.21
Code: 0xC020209C
Source: Load Data Flat File Source [1]
Description: The column data for column "COLUMN NO 1" overflowed the disk I/O buffer.
End Error
Error: 2010-08-10 11:52:33.21
Code: 0xC0202091
Source: Load Data Flat File Source [1]
Description: An error occurred while skipping data rows.
End Error
Error: 2010-08-10 11:52:33.21
Code: 0xC0047038
Source: Load Data SSIS.Pipeline
Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Flat File Source" (1) returned error code 0xC0202091. 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.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 11:52:03 AM
Finished: 11:52:33 AM
Elapsed: 30.109 seconds

Advertisements

One Reply to “SSIS Error Code 0xC020209C & SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s