SSIS Converting text to scientific notation

Question

SSIS Converting text to scientific notation

bgraybill

SSC Enthusiast

Points: 142
More actions
March 18, 2008 at 9:35 am

#122704

I have created a SSIS package to import data from an Excel spread sheet. I have added IMEX=1 to the connection string of the excel source to bring in all data as text. However, the package still converts the field from time to time into scientific notation. Does anyone know how to resolve this? Thanks.
Bob

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Chinna SSCertifiable Points: 5408 More actions · Answer 1

hi I am curious to know that what is IMEX i jus want ot know that and where can i set that to one i couldnt find it in properties..plz let me know

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman

bgraybill SSC Enthusiast Points: 142 More actions · Answer 2

It is a property on the connection string for the excel source. Unfortunately, there is not a box to set it. you have to add it directly to the connection string. It tells SSIS to ignore data type and bring everything in as text.

Chinna SSCertifiable Points: 5408 More actions · Answer 3

but i couldnt understand where should i add it to the connection string could u provide me an exapmle of one of urs file with that imex plzzz...thkz for ur response

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman

Chinna SSCertifiable Points: 5408 More actions · Answer 4

is this only for excel or any source i mean flat file also...

Thanks,
Chinna

Its the Journey which gives you Happiness not the Destination-- Dan Millman

Jay1234 SSCommitted Points: 1624 More actions · Answer 5

I think you should use Data Conversion transformation