We are running SQL Server 2016 and Visual Studio 2017 and are trying to import a sample file that has extra text qualifiers inside the data. It previews ok but during runtime, it errors out on record# 2 because - Error 0xc0202055: Data Flow Task 1: The column delimiter for column ""COLUMN1"" was not found. (SQL Server Import and Export Wizard)
| "COLUMN1" | "COLUMN2" |
|---|---|
| "KEVIN THOMAS" | "123 Main Street" |
| "GEORGE "Geo" LEWIS" | "345 Tree Line Ave" |
I thought this issue was fixed in SQL Server 2016.
I tried using SSMS import wizard and Visual Studio 2017 and get the same errors.