Loading the delimited file to the table

[adimulam]

Hi ALl,
I have a flat file (Pipe delimited) with 200,000 records in it. I am using DTS to load the data into a table. I am getting the following error.

Error at Source for Row number 32154. Errors encountered so far in this task: 1.
Error Source: Microsoft Data Transformation Services Flat File Rowset Provider
Error Description:Column Delimiter not found.

I went to the corresponding row and checked the data and I found two of the fields are coming as follows.

|XXXX "CHOICE"|"CHOICE" XXXXX|

I corrected the above two fields as
|XXXX "CHOICE"|CHOICE XXXXX|

Then it loaded all 200,000 records fine.

But I want quotes around the CHOICE in the 2nd field.

Does anyone know why it is doing it and the way to get around it?. I appreciate it.

Adimulam.

 

[amrita418]

Double check if the text qualifier option is set to <none>.

I was able to test load the data with the double quotes just fine.

Regards,
AA