Вопрос:

SSIS: how to handle a quote-qualified csv file with quotes inside quotes

ssis

401 просмотра

1 ответ

716 Репутация автора

I'm working in SQL Server 2008 R2. I have an SSIS package that imports a csv file into a table. The given csv file is quote-qualified. Because the file is quote-qualified, in its corresponding flat file connection, I specified Text qualifier = ". However, the import fails because of a particular row in the file. The given row has quotes inside of quotes. For example:

"a","1","","text""moretext","","1.0"

The package throws the error:

The column delimiter for column <> was not found.

I still want the row (and rows like it) to be imported. How can I handle this in SSIS?

Автор: skyline01 Источник Размещён: 08.11.2017 11:15

Ответы (1)


0 плюса

29222 Репутация автора

Решение

You can't do it with a flat file source.

You can write a custom script (either a complete script task or a script source component), or you can import it with BCP and a format file.

Автор: Tab Alleman Размещён: 09.11.2017 01:25
Вопросы из категории :
32x32