Page 1 of 1

Delimiter not seen at offset issue

Posted: Wed Aug 07, 2013 12:23 am
by partha.natta
We are facing an issue while loading a delimited file into sql server database.
The metadata is defined in schema file as mentioned below.

record
{record_delim='\n', delim='|',final_delim=none, quote=NONE}
(
Col1:nullable string[1] {null_field=''};
Col2:nullable string[5] {null_field=''};
Col3:nullable string[10] {null_field=''};
Col4:nullable string[10] {null_field=''};
Col5:nullable string[10] {null_field=''};
Col6:nullable string[10] {null_field=''};
)

The table definition also same as the schema file.
but we are getting an error saying that, Field "Col2" delimiter not seen, at offset: 7

Posted: Wed Aug 07, 2013 1:00 am
by ray.wurlod
Your data lacks the pipe delimiter following col2. Does the error message mention the row number at which this occurred? If row 0, how is the "first line is column names" property set?