SSIS Flat File error "Text was truncated or one or more characters had no match in the target code page."

Question

I am working on a SSIS project. I have a Flat File Source (csv) and OLE DB as destination. I have a column named WrapUpName with a data type Unicode string [DT_WSTR] with a Outputcolumnwidth - 50 that only contains either of these data Successfull,Unsuccessfull,ACPS FC: Always Busy or Ringing or Unattended and my destination column is nvarchar(50)

I had these error message

Data conversion failed. The data conversion for column "WrapUpName" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page."

It's really weird because upon checking of the error row the data in column WrapUpName is Successfull which is handled by my IS with no problem. Upon researching I know that the fix is setting code page to UTF-8 which I did from the first time or adjusting the length of data type which is correct but I want to know what triggered the error.

Answer 1

Check out this link:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/32129879-90e1-491e-8c80-f3c3cf6eb0e0/how-to-avoid-truncation-error-in-ssis-for-flat-file?forum=sqlintegrationservices

Two ways for addressing the problem are described.