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.
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.
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?
Much appreciated...