无法解决平面文件截断错误 [英] Can't get past flat file truncation error

问题描述

在WIN Server 2016上使用SSDT 2015

我有一个固定宽度的平面文件输出。 其中一个领域是"患者名字"。并且每个固定宽度限制为14个字符。

在OLe DB数据源源列中设置为忽略"错误"和"错误"两者的失败。和"截断"

在FlatFile高级编辑器中，在"输入和输出属性"下。在外部列下，"长度"设置为14并且在"输入列"下，有一个名为"TruncationRowDisposition"的项目，它设置为RD_NotUsed
但是显示为灰色。

在& ; FlatFile连接管理器"在"高级"下左侧的标签，此字段的"InputColumnWidth"和OutputColumnWidth"两者都设置为14。

无法通过此错误来挽救我的生命，任何帮助都将受到赞赏。

执行结果错误：

1. [平面文件目的地1 [2]]错误：数据转换失败。列"患者名字"的数据转换返回状态值4和状态文本"文本被截断或目标代码页中的一个或多个字符不匹配。"。
2. [平面文件目标1 [2]]错误：无法复制或转换列"患者名字"的平面文件数据。
3. [SSIS.Pipeline]错误：SSIS错误代码DTS_E_PROCESSINPUTFAILED。 组件"Flat File Destination 1"上的ProcessInput方法（2）在处理输入"平面文件目的地输入"时错误代码为0xC02020A0。 （6）。
   标识的组件从ProcessInput方法返回错误。该错误特定于组件，但错误是致命的，将导致数据流任务停止运行。 在此之前可能会发布错误消息，其中包含有关失败的更多信息
   。

解决方案

KenDefunk，

是否可能列"患者名字"？有以下问题：

• 它的长度超过14个字符。
• 它包含一些不匹配你的奇怪字符代码页。

调查的最佳方法是查看源数据。

Using SSDT 2015 on WIN server 2016

I have a fixed width flat file output.  One of the fields is "Patient First Name" and is limited to 14 characters per fixed width.

In OLe DB Datasource Source column is set to ignore failures on both "error" and "Truncation"

In the FlatFile advanced editor, under the "Input and Output Properties" under External Columns, "length" is set to 14 and under "input columns", there is an item called "TruncationRowDisposition", it is set to RD_NotUsed but is grayed out.

In the "FlatFile Connection Manager" under the "advanced" tab at left, this field's "InputColumnWidth" and OutputColumnWidth" are both set to 14.

Can not get by this error to save my life, any help would be appreciated.

EXECUTION RESULTS ERRORS:

1. [Flat File Destination 1 [2]] Error: Data conversion failed. The data conversion for column "Patient First Name" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
2. [Flat File Destination 1 [2]] Error: Cannot copy or convert flat file data for column "Patient First Name".
3. [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "Flat File Destination 1" (2) failed with error code 0xC02020A0 while processing input "Flat File Destination Input" (6). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.  There may be error messages posted before this with more information about the failure.

解决方案

Hi KenDefunk,

Is it possible that the column "Patient First Name" has the following issues:

• Its length is more than 14 chars.
• It contains some weird characters not matching your code page.

The best way to investigate is to look into your source data.

这篇关于无法解决平面文件截断错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！