D
doofy
I know this is more of a Sql Server question, but I haven't gotten a
response on that newsgroup as of yet.
I've got a SQL Server SSIS package that takes data from a SS table, and
sends it to an Excel destination.
When it lands in Excel, the numeric data is being saved as text, which
means the charts that I have pointing to those data areas are not
showing any values.
If the fields are int's in SS, why are they getting written as text in
Excel? How can I intercede? I've tried looking at the definition of
the porting mechanism, but it doesn't give me any handles to tweak.
I tried formatting the XL columns to numeric, but that doesn't work, as
I suspected it would not.
response on that newsgroup as of yet.
I've got a SQL Server SSIS package that takes data from a SS table, and
sends it to an Excel destination.
When it lands in Excel, the numeric data is being saved as text, which
means the charts that I have pointing to those data areas are not
showing any values.
If the fields are int's in SS, why are they getting written as text in
Excel? How can I intercede? I've tried looking at the definition of
the porting mechanism, but it doesn't give me any handles to tweak.
I tried formatting the XL columns to numeric, but that doesn't work, as
I suspected it would not.