SSIS - Text was truncated or one or more character

问题:

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

回答1:

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