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
This question is related to
ssis
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
Source: Stackoverflow.com