Hello, i want to load data from an excel file into a mysql database. I have this problem "For input string : 169.36" (when the value of the colum is for example 147,00 there is no pb, but when it's for example 178.36) i got the error above.
be sure that all rows have the same structure. as sanvaibhav said, it's a metadata problem. Your try to read some data with a wrong structure. If you cannot find the wrong one, use tSchemaCompliancecheck against expected structure and catch reject + error that show yous where problem(s) 's occured. hope it help regards laurent
hi, For that value data type in job you may have given INT. but your getting DECIMAL values. There should be proper DATA TYPE between your data and file component. from file component uncheck "Die on error", and give reject flow to one temporary file. then all rejected rows will be captured in that file. Regards, Akki
This is common metadata issue.. when input column metadata does not matches with the defined metadata, this error will come... Pl check metadata against the data for that particular record. Vaibhav
Thank you very much. I was looking around for any solution but with no lucky, however you gave me the key. In fact, the problem was the metadata where I had a column with decimal values, defined as Integer. After I've changed this column to Double the problem has gone.