ssis - DTS_E_PRIMEOUTPUTFAILED with error code 0xC0202091 when loading flat file -


i error message when try run ssis package error is:

[flat file source [1]] error: column delimiter column "column 8" not found.

[flat file source [1]] error: error occurred while skipping data rows.

[ssis.pipeline] error: ssis error code dts_e_primeoutputfailed. primeoutput method on component "flat file source" (1) returned error code 0xc0202091. component returned failure code when pipeline engine called primeoutput(). meaning of failure code defined component, error fatal , pipeline stopped executing. there may error messages posted before more information failure.

most of csv files load no problem handful of csv files don't , prior package has been working fine years.

encountered error too, turned out skipping data rows because csv file has missing columns. try checking if columns in file correct.


Comments