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

Popular posts from this blog

jquery - How can I dynamically add a browser tab? -

node.js - Getting the socket id,user id pair of a logged in user(s) -

keyboard - C++ GetAsyncKeyState alternative -