SSIS 数据转换失败 [英] SSIS data conversion failed

问题描述

我在尝试执行 SSIS 包时收到此错误.

I am getting this error when trying to execute the SSIS package.

[平面文件目标 [22]] 错误:数据转换失败.数据列DC"的转换返回状态值 4 和状态文本文本被截断或一个或多个字符在目标代码页.".

[Flat File Destination [22]] Error: Data conversion failed. The data conversion for column "DC" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

该列的大小为 10，我希望输出为 4，我在我的平面文件中设置了该列，但无法正常工作.

The column is of size 10 and I want that to be 4 in output, I had that set in my flat file but is not working.

请告知我哪里出错了.

问候五、

推荐答案

如果您不想弄乱平面文件属性，您可以修剪数据源中的值.IE SELECT SUBSTRING(Column,1,4) AS Column FROM Table.

If you don't want to mess with the Flat File properties, you could trim the value in your data source. IE SELECT SUBSTRING(Column,1,4) AS Column FROM Table.

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