Number data is not in proper format

Answered

David Paras

• August 09, 2016 19:39

I am trying to process an incoming csv file, but the following error record is being generated

 

</SourceRecord>
<ErrorDescription  >Number data is not in proper format: field name = Employee_Number and value = &quot;9611&quot;</ErrorDescription>
</ErrorRecord>

 

 

0

• Official comment

  

  David Paras

  • August 09, 2016 19:40

  While parsing the file, the schema is trying to interpret "9611" as a number value which fails because of the quotes. Please set the "Handle Enclosing Character" value to " (in the Advanced Properties)

  Also, make sure the "Quotes Handling On" option is selected.

  This will allow the file to be parsed successfully.

Post is closed for comments.