I'm having trouble reading scientific notation from a CSV. I am trying to convert to DECIMAL using the Read CSV task using different patterns, but I can't get past this error:
Column data '3.2e+06' is not valid for its data type 'DECIMAL'
I've tried using various patterns with 'E' such as 'E##' etc., but I'm not even sure I'm on the right track.
I would really appreciate help with this. Thank you in advance!