sql - SSIS Flat File Import errors

Question

I have a ssis job that imports flat file data into my database and also data conversion. Please find a view of the scheme:

The issue is that I keep getting errors on the "Violations" field see below:

[Flat File Source [37]] Error: Data conversion failed. The data conversion for column "Violations" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

[Flat File Source [37]] Error: The "Flat File Source.Outputs[Flat File Source Output].Columns[Violations]" failed because truncation occurred, and the truncation row disposition on "Flat File Source.Outputs[Flat File Source Output].Columns[Violations]" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. [Flat File Source [37]] Error: An error occurred while processing file "C:UsersXXXXXXXXXXXXXXXXXXXXXXXXXXXXFood_Inspections.csv" on data row 25.

In line 25 of the CSV file, this field is over 4000 characters long. In data conversion, I currently have the Data Type set to string [DT_STR] of length 8000, coding 65001. Row delimiter {LF}, Column delimiter Semicolon {;} I have already looked at other suggested solutions, i.e. increasing OutputColumnWidth to 5000 but it did not help - please advise how to solve this.

question from:https://stackoverflow.com/questions/65869529/ssis-flat-file-import-errors

Answer 1

Waitting for answers