SSIS:Issue with data from a csv file:

Question

Issue with data from a CSV file: I downloaded some file in CSV with some values like this one: 1.21E+11, when the values are too long.

If I convert to XLS/XLSX and change the field to numeric, that fixes the issue, but I want to do something automatized.

Answer 1

Try adding a derived column of type DT_R8 and use the following expression:

(DT_R8)[InputColumn]

As shown in the image below, i tested the following expression:

(DT_R8)"1.21E+11"

And the result was:

121000000000