devguru001
asked on
SSIS - Importing scientific notation field to SQL DB using SSIS
Hi
I am trying to import a column from an excel source. It has a "general" type in excel and therefore shows as follows: 8.938E+19
I want to import it into SQL by showing it as its numeric value of: 89380000000004700000
I am attempting to use a derived column and would like to know what I should convert it to in order to import it into the DB.
I am trying to import a column from an excel source. It has a "general" type in excel and therefore shows as follows: 8.938E+19
I want to import it into SQL by showing it as its numeric value of: 89380000000004700000
I am attempting to use a derived column and would like to know what I should convert it to in order to import it into the DB.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
My source data supplier was willing to change the column from "General" to "Number".
ASKER
I defined the table column as nvarchar100.
I have a derived column in my ssis package: (DT_NUMERIC,30,0)[fieldtoc
It still shows in scientific notation after running the package. Any thoughts?