SSIS: Data conversion failed from a Flat File Source

0

Good day. The following are the errors that had occured while processing the flat file:

  • Error: 0xC02020A1 at Task, File [1]: Data conversion failed. The data conversion for column "Column 0" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
  • Error: 0xC020902A at Task, File [1]: The "output column "Column 0" (14)" failed because truncation occurred, and the truncation row disposition on "output column "Column 0" (14)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
  • Error: 0xC0202092 at Task, File [1]: An error occurred while processing file "filepath" on data row 1.
  • Error: 0xC0047038 at Task, SSIS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Retrieve Input Batch File" (1) returned error code 0xC0202092. 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.

Source File is a Flat File Data Type properties for External Column and Output Column is identical: Data Type: String [DT_STR] Length is 1143

I've tried to experiment with the values in the properties, but I got no luck. What could be the reason for the error?

In addition, I tried to test 2 files. First file got success result, while the latter did not. Difference between them is, the first one is Dos\Windows, while the other is UNIX. Does it affect the behavior of the flat file?

Thank you so much for your input :)

windows
ssis
bids
flat-file
asked on Stack Overflow Oct 5, 2016 by newbie • edited Oct 6, 2016 by Ross Ridge

1 Answer

0

Go to your flat file connection manager>>> Flat file Source Editor then >>> Click on Error Output >>>> and then to the column in question and select Ignore Failure. This worked for me. (That is if the column size is right)

answered on Stack Overflow May 20, 2019 by Ernest

User contributions licensed under CC BY-SA 3.0