SSIS - Text was truncated or one or more characters had no match in the target code page - Special Characters

Question

I have a text file with Vertical Bar    separated values and I am using a Flat File source to read the values which fails with the above error   I have a Flat File Connection Manager  where I set the columnwidth of each column  The particular column which causes error has   DataType - DT WSTR  OutputColumnWidth - 30  The problem is raised only when the particular column has special characters like  Soci  t   Amomyna da Pramt Hgyme  though it still has only 30 characters   If I increase the column width it works but I need to know is that the right solution   Please let me know if you require more details  Thanks in advance

User · Accepted Answer

If you go to the Flat file connection manager under Advanced and Look at the "OutputColumnWidth" description's ToolTip It will tell you that Composit characters may use more spaces. So the "é" in "Société" most likely occupies more than one character.

EDIT: Here's something about it: http://en.wikipedia.org/wiki/Precomposed_character

[ssis] SSIS - Text was truncated or one or more characters had no match in the target code page - Special Characters

Examples related to ssis