I have an excel spreadsheet with a column "Premium", number format, 2 decimal places.
I have a table with "Premium" field, numeric(10,2).
I created a SSIS data flow from the table (OLE Source) to the spreadsheet (Excel Destination).
the task runs fine, but when I open the spreadsheet, the "Premium" column has an error note stating that I have a text value in a column formatted for number. the exported numbers look good (100.01), but I cannot sum them or get rid of the error without manual intervention.
What can I do to get Excel to recognize the database table number as numeric?