SSIS将其设置为CRLF时读取LF作为终止符 [英] SSIS reading LF as terminator when its set as CRLF

问题描述

使用SSIS2012.我的平面文件连接管理器中有一个定界文件，其中行分隔符设置为CRLF，但是在处理文件时，我有一个文本列，其中包含LF.这导致它将其读取为行终止符，从而导致失败.有什么想法吗?

using SSIS 2012. My flat file connection manager I have a delimited file where the row delimiter is set to CRLF, but when it processes the file, I have a text column that has an LF in it. This is causing it to read that as a row terminator causing it fail. Any ideas?

推荐答案

感谢您的所有建议.原来，供应商已将文件的编码从Ascii更改为unicode.更改软件包以读取正确的编码就可以了.

thank u for all the suggestions. turned out that the vendor had changed the encoding of the file from Ascii to unicode. changing the the package to read the correct encoding did the trick.

这篇关于SSIS将其设置为CRLF时读取LF作为终止符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！