错误：转换列时数据转换失败 [英] Error: Data conversion failed while converting column

问题描述

这是我一直遇到的错误。

This is the error I kept getting.

[数据转换0 - 0 [2]]错误：转换列"FirstDetection"时数据转换失败（83）栏目"FirstDetection" （11）群组。转换返回状态值4和状态文本"文本被截断，或者一个或多个
字符在目标代码页中没有匹配。"。

[数据转换0 - 0 [ 2]]错误："数据转换0 - 0.Outputs [数据转换输出] .Columns [FirstDetection]"失败，因为发生截断，并且截断行处置"数据转换0 - 0.Outputs [数据转换输出] .Columns [FirstDetection]"
指定截断失败。指定组件的指定对象发生截断错误。

[SSIS.Pipeline]错误：SSIS错误代码DTS_E_PROCESSINPUTFAILED。 组件"数据转换0-0"上的ProcessInput方法（2）在处理输入"数据转换输入"时失败，错误代码为0xC020902A。 （3）。标识的
组件从ProcessInput方法返回错误。该错误特定于组件，但错误是致命的，将导致数据流任务停止运行。 在此之前可能会发布错误消息，其中包含有关
失败的更多信息。

[Data Conversion 0 - 0 [2]] Error: Data conversion failed while converting column "FirstDetection" (83) to column "FirstDetection" (11).  The conversion returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
[Data Conversion 0 - 0 [2]] Error: The "Data Conversion 0 - 0.Outputs[Data Conversion Output].Columns[FirstDetection]" failed because truncation occurred, and the truncation row disposition on "Data Conversion 0 - 0.Outputs[Data Conversion Output].Columns[FirstDetection]" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "Data Conversion 0 - 0" (2) failed with error code 0xC020902A while processing input "Data Conversion Input" (3). 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.

这就是我在数据转换中所拥有的。

And this is what I have in the Data Conversion.

推荐答案

好的，我明白了。我没有指定规模，这就是它失败的原因。

Okay, I figured it out. I did not specify the Scale that's why it failed.

这篇关于错误：转换列时数据转换失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！