DSXchange

Hi All,

Iam getting the following error my source is txt file its has field delimiter as | and record delimiter none and no quotes in the source data and ID is the field name.

I appriciate if some one can help me this error
Field "ID" delimiter not seen, at offset: 7

Thanks

Do you have an example of the source file that you can paste? Please include several records

Also, your column definitions (including datatype) or better yet an orchestrate schema if you can. For the column ID, how is it defined? Char(7), VarChar() or such?

Regards,

The error is self explanatory buddy!

Field "ID" delimiter not seen, at offset: 7

There is no delimiter, or it's corrupted due to a delimiter withing the same data itself so it got confused. It's one of the columns beginning/ending that is wrong, the issue doesn't have to be on the offset 7 exactly, check data before it.

Best!