BulkInsert: Small decimal number in json given scientific notation format

[vskaret]

Hi,

I have an issue using the Frends.Sql.BulkInsert task where a small decimal number in the JToken is formatted with scientific notation on insertion. It crashes with the exception "The given value of type String from the data source cannot be converted to type float of the specified target column." Specifically, there is a decimal value 0.000000741 which is turned into 7.41e-7. I am almost certain this is the reason because when changing this field's value, the BulkInsert runs successfully.

Do you know if there is a way to work around this other than changing the datatype of the table in the destination database as suggested here?

Some more information:

I am moving data from an oracle database to an mssql server database.

Here is the row as output by the oracle db:

Here is the row as displayed in the Input.Input data in the BulkInsert log:

Here is most of stack trace of the exception: