1 year ago

#384893

test-img

nam

Import/Export Wizard and quote delimiter issue

Why I am getting the following error, and how can we fix it?

Error 0xc0202055: Data Flow Task 1: The column delimiter for column "Col1" was not found. (SQL Server Import and Export Wizard)

I'm using the latest version (18.11..) of Microsoft SQL Server Management Studio (SSMS) to import data from a 500MB text file that has | as a column terminator. As shown in the image below, I'm using Text Qualifier as double quotes " and there is no | character inside the Col1 column, and the column is delimited by |.

enter image description here

sql-server

sql-server-2019

0 Answers

Your Answer

Accepted video resources