Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

export IMEI to excel

Status
Not open for further replies.
rwaldron

rwaldron

MIS
Aug 6, 2002
53
IE
Hi all,
I am trying to export from sql table to excel in SSIS
there 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..
 
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
CSV to SQL table with not allow null issue
Replies
3
Views
445
Cpreston
Cpreston
minhtran360
  • Locked
  • Question
Where do I look for my SSIS pasckage that just being deployed to my sql server?
Replies
1
Views
1K
mark williams
mark williams
grnzbra
  • Locked
  • Question
Excel Import Maps 255 Char Max
Replies
0
Views
296
grnzbra
grnzbra
dbsql
  • Locked
  • Question
get existing record from source to destination
Replies
0
Views
260
dbsql
dbsql
kfschaefer0727
  • Locked
  • Question
New to SSIS - Create pkg to validate data, does it exists in a table
Replies
0
Views
270
kfschaefer0727
kfschaefer0727

Part and Inventory Search

Sponsor

Back
Top