SSIS平面文件列分隔符问题 [英] SSIS Flat file column delimiter issue

问题描述

你好，

我有没有办法停止将数据移到SSIS的下一栏？

Is there way I can stop moving data to next column in SSIS?

我正在使用"在平面文件设置中的文本限定符中。

I'm using " in text qualifier in flat file setup.

基本上数据我有很多逗号和双引号，请参阅附图。一张图像来自SSIS>平面文件连接管理器和.csv文件中的另一个显示移动数据。 

Basically on the data I have many commas and double quotes, please see attached images. One image is from SSIS> Flat file connection manger and another one from .csv file which is show up moved data. 

我有办法解决这个问题吗？ 

Is there way I can solve this? 

推荐答案

您好Danny2426，

Hi Danny2426,

该文件可能有一些"CRLF字符"之后的"CRLF字符"。 （引号）。

The file likely has CRLF chars after some of the " (quotes).

我建议您使用允许查看不可打印字符的编辑器检查文件内容。它可能是EmEditor，Notepad ++等。

I suggest you inspect the file contents using an editor that allows seeing non-printable characters. It could be EmEditor, Notepad++, etc.

这篇关于SSIS平面文件列分隔符问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！