Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rwaldron
Posting Yak Master
131 Posts |
 Posted - 2009-06-25 : 07:26:53
|
| Hi all,I am trying to export from sql table to excel in SSISthere is an IMEI column in SQL containing data like 123456789123456.When I export to excel the data is displayed as 1.23E+14.If I format in excel the cell to number and 0 decimals I get the 123456789123456 back.My question is what data type in SSIS,precision and scale should i use to format the output correctly.In SSIS Mappings there is a decimal data type?Thx,Ray.. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-25 : 07:30:00
|
The problem is not SSIS, it is Excel which tries to guess the datatype for the data.You can add s single (') to the beginning of the data and Excel will not try to convert text to numeric.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
kumar1248
Starting Member
20 Posts |
Posted - 2009-06-25 : 12:47:01
|
| Peso's suggestion is one way of doing it. Also try by specifying IMEX=1 property in the connection string of EXCEL. |
|
|
|
|
|
|
IMEI Data type ???