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 |
|
jbphoenix
Yak Posting Veteran
68 Posts |
 Posted - 2009-07-17 : 17:34:54
|
| Here's the situation - I created an excel template. Then in my ssis package I copy the excel template and rename it. Then a query runs and puts the data in the excel template. But when the data gets to excel the format is changed to text. The data is coming from numeric data types. I need the data to stay numeric because the excel template has multiple tabs and the tabs do calculations on the imported data. If it's not numeric it doesn't work. How do I get the data to stay numeric? |
|
|
jbphoenix
Yak Posting Veteran
68 Posts |
Posted - 2009-07-17 : 17:55:22
|
| Here's a little more info - the excel template is formatted for numbers. When the data from ssis gets to the excel tab the format of the excel tab is now General. |
 |
|
|
|
|
|
Exporting to excel changing format