SSIS 2008 和 Undouble [英] SSIS 2008 and Undouble

问题描述

我在 SQL Server 2008 R2 中使用 SSIS.我正在导入大型文本文件(大约 0.5 Gb)，这些文件使用双引号作为文本限定符，使用逗号作为字段分隔符.

I am using SSIS with SQL Server 2008 R2. I am importing large-ish text files (approx 0.5 Gb), and these files use double quotes as a text qualifier, and the comma as a field delimiter.

许多文件都有文本限定字段，并在终止的双引号之间包含一个逗号.SSIS 应该将其解释为单个字段(恰好包含逗号的字段).相反，它将其解释为两个不同的字段.

Many of the files have text qualified fields and include a comma between the terminating double quotes. SSIS should interpret this is a single field, (one that happens to contain a comma). Instead, it interprets it as two different fields.

我可以找到很多 SQL 2005 的变通方法——通常在undouble"的标题下——但我能找到的唯一 2008 变通方法需要一些复杂的编程.有没有人有任何简单的 2008 解决方法?

I can find plenty of workarounds for SQL 2005 - generally under the heading of "undouble" - but the only 2008 workarounds I can find require some complex programming. Does anyone have any simple 2008 workarounds?

非常感谢...

推荐答案

对于任何有类似问题的人，请参阅 http://ssisdfs.codeplex.com/releases/view/32846.

For anyone with similar issues, see http://ssisdfs.codeplex.com/releases/view/32846.

从 codeplex 下载的 DFS 2008 绝对是赢家.

The DFS 2008 download from codeplex is an absolute winner.

这篇关于SSIS 2008 和 Undouble的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！