SSIS - 文本被截断或一个或多个字符在目标代码页中没有匹配项 - 特殊字符 [英] SSIS - 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

数据类型 - DT_WSTR

OutputColumnWidth - 30

仅当特定列具有特殊字符(例如Société Amomyna da Pramt Hgyme"，尽管它仍然只有 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

推荐答案

如果你转到 Advanced 下的 Flat file connection manager 并查看OutputColumnWidth"描述的 ToolTip 它会告诉你 Composit 字符可能会使用更多空格.因此，Société"中的é"很可能占据多个字符.

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.

编辑:这是关于它的一些内容:http://en.wikipedia.org/wiki/Precomposed_character

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

这篇关于SSIS - 文本被截断或一个或多个字符在目标代码页中没有匹配项 - 特殊字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！