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 |
|
ellison
Starting Member
1 Post |
 Posted - 2009-12-22 : 18:03:47
|
| This thing has been driving me nuts!I'm exporting to Excel 2007. I've got the empty template that I am copying to my destination location before I export. It doesn't seem to matter how I built my sheets in the file, as soon as I delete my sample data, SSIS starts exporting my numeric data as strings.How do I export my data as numeric data to an empty sheet?Dan |
|
|
behrman
Yak Posting Veteran
76 Posts |
Posted - 2010-01-03 : 10:25:52
|
Hi, ellison.In my opinion, you can have a try of RAQ Report.With it, you can export report to Excel eaily without any difference.An example is shown below:  I wish this can be helpful.Good luck. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-03 : 11:34:08
|
quote:
Originally posted by ellison
This thing has been driving me nuts!I'm exporting to Excel 2007. I've got the empty template that I am copying to my destination location before I export. It doesn't seem to matter how I built my sheets in the file, as soon as I delete my sample data, SSIS starts exporting my numeric data as strings.How do I export my data as numeric data to an empty sheet?Dan
have you checked the datatype of columns in metadata of ssis? if they're string can you try converting them explicitly using datatype conversion task. |
|
|
|
|
|
|
Numeric in Empty Excel Destination