Wednesday, 21 August 2013

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

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

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 increase the column width it works but I need to is that the right
solution to increase a much higher column width.

No comments:

Post a Comment