November 6, 2009 at 2:52 pm
I have a package that creates spreadsheets. The issue is this.
The SQL table has the column defined as float.
This column is created on the xls as string.
I looked at the advanced editor in SSIS for that spreadsheet. The column is defined as DT_CY and it translates to DT_WSTR. How do I make the output be
a numeric.
On the xls, there is a little green marker. When I click on it does change the DT_WSTR to Numeric. I want SSIS to spool the correct format.
December 7, 2011 at 3:59 pm
Greengiant....is there some special knowledge I need to move data from a table in a db to an xls?? I get conversion errors and it won't work. Can't seem to see the issue. Never done an SSIS package before....playing with the wizard. Any words of wisdom???
Thank you in advance....
December 7, 2011 at 11:45 pm
Angelindiego (12/7/2011)
Greengiant....is there some special knowledge I need to move data from a table in a db to an xls?? I get conversion errors and it won't work. Can't seem to see the issue. Never done an SSIS package before....playing with the wizard. Any words of wisdom???Thank you in advance....
So you are asking a person who had a conversion problem back in 2009?
It would have been easier to just start a new topic.
Anyway, please post the error message that you got.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 8, 2011 at 8:55 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply