SSIS错误 - 截断 [英] SSIS Error - Truncation
问题描述
来源:获取数据[2289]描述:输出列cust_store存在错误。 (2560)在输出OLE DB源输出上(2299)。返回的列状态为:文本被截断,或者目标代码页中的一个或多个字符不匹配。。结束错误错误:2014-03-17 11:01:52.79代码:0xC020902A来源:获取数据[2289]描述:输出列cust_store" (2560)"失败,因为发生了截断,并且输出列上的截断行处置cust_store (2560)"指定截断失败。指定组件的指定对象上发生截断错误。结束错误错误:2014-03-17 11:01:52.79代码:0xC0047038来源:获取数据描述...包执行...步骤失败。
Source: Get Data [2289] Description: There was an error with output column "cust_store" (2560) on output "OLE DB Source Output" (2299). The column status returned was: "Text was truncated or one or more characters had no match in the target code page.". End Error Error: 2014-03-17 11:01:52.79 Code: 0xC020902A Source: Get Data [2289] Description: The "output column "cust_store" (2560)" failed because truncation occurred, and the truncation row disposition on "output column "cust_store" (2560)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. End Error Error: 2014-03-17 11:01:52.79 Code: 0xC0047038 Source: Get Data Descriptio... The package execution fa... The step failed.
推荐答案
当列的大小超过时会出现此错误。
例如:在db中你有一个列varchar(50)
和你的包你有varchar(40)
然后你会得到这个错误
或
例如:在db中你有一个列varchar(50)
和你的包你有varchar(50)
和你的平文件或sql源可能有超过50然后我会得到这个错误
解决方案:所有ull要做的就是增加列的大小..
ull get this error when the size of the column exceed.
eg: in db u have a column varchar(50)
and in ur package u have varchar(40)
then u will get this error
or
eg: in db u have a column varchar(50)
and in ur package u have varchar(50)
and in ur flat file or sql source may have more than 50 then ull get this error
Solution: all ull have to do is increase the size of the column..
这篇关于SSIS错误 - 截断的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!