Geek Answers Handbook

SSIS 2008 and Undouble

I am using SSIS with SQL Server 2008 R2. I import large text files (about 0.5 GB), and these files use double quotes as a classifier for text, and a comma as a field separator.

Many of the files have text fields and include a comma between trailing double quotes. SSIS must interpret this one field (which contains a comma). Instead, he interprets it as two different fields.

I can find many workarounds for SQL 2005 - usually under the heading "undouble" - but the only workarounds of 2008 that I can find require some complicated programming. Does anyone have any easy workarounds for 2008?

Very much appreciated ...

+4
ssis
source share
2 answers

For those who have similar problems, see http://ssisdfs.codeplex.com/releases/view/32846 .

Downloading DFS 2008 from codeplex is an absolute winner.

+1
source share

Use three double quotes instead of single double quotes for “Text Qualifier” in “Flat File Manager Editor” ... Simple!

-one
source share

More articles:


All Articles