请教一个 SSIS的问题，万分感谢！

澳贼

ｌｏａｄ　一个　ｆｌａｔ　ｆｉｌｅ．
其中一个ｃｏｌｕｍｎ里的数据包含ｎｅｗｌｉｎｅ　ｃｈａｒａｔｅｒ（＇＼ｎ＇）．

所以每次都报错。


[Flat File Source [1]] Error: The "output column "Column 13" (300)" failed because truncation occurred, and the truncation row disposition on "output column "Column 13" (300)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.

哪位高手解惑，万分感谢！

roo81

放word里，先清理了它再说

澳贼

原帖由 roo81 于 2010-9-20 15:35 发表
放word里，先清理了它再说

谢谢参与。

北风

改一下你的row delimiter

原帖由 澳贼 于 20/9/2010 15:34 发表
ｌｏａｄ　一个　ｆｌａｔ　ｆｉｌｅ．
其中一个ｃｏｌｕｍｎ里的数据包含ｎｅｗｌｉｎｅ　ｃｈａｒａｔｅｒ（＇＼ｎ＇）．

所以每次都报错。


[Flat File Source [1]] Error: The "output column "Column 13" (300)" failed because truncation occurred, and the truncation row disposition on "out ...

dayang

i don't think the error has anything to do with '\n'. as the message suggests, your source contains more than your column size. increase your column size for column 13.