使用SSIS，平面文件连接管理器弄乱具有“，”的csv文件，在数千的范围内 [英] With SSIS, the flat file connection manager messes up with csv files having "," in values in the range of thousands

问题描述

我有一个CSV文件中的数据，它显示在记事本中，如下所示：

在SSIS中，当我尝试以分隔格式加载此文件时，由于在数值中出现的逗号，预览会变得混乱，例如。在数千和数百万。数据类似如下：

有什么方法可以在连接管理器中处理这个问题吗？

解决方案

使用文本限定符 p>

这将处理在里面有引号的列。有时它对CSV数据非常糟糕，我不得不诉诸脚本组件做一些清理，但这是非常罕见的。

I had data in a CSV file, which appears in a notepad something like this:

In SSIS, when I try to load this file in a Delimited format, the data which appears in the preview gets messed up due to the commas which occur in the numeric values, eg. in thousands and millions. The data looks something like this:

Is there any way in which this problem can be taken care of in the connection manager itself ?

Thanks!

解决方案

Use Text Qualifier as shown here:

This will take care of the columns that have quotes inside. Sometimes it gets really bad with CSV data, and I've had to resort to script components doing some cleanup, but that's really rare.

这篇关于使用SSIS，平面文件连接管理器弄乱具有“，”的csv文件，在数千的范围内的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！