I'm hoping someone can help me, I've explored google to death and I just can't seem to find the answer. I'm new to using SSIS, so I don't know if this is possible...I am exporting data from SQL server database to an Excel file, which works well but it exports all numeric as string. I then have to go in a manually convert it to numbers. The source of the data is definitely numeric but SSIS recognises the destination cells as UNICODE STRING. I've tried changing the format of the cells in the excel template and tried to use the import export wizard but to of no avail. Is there something I am missing?
A:
The trick is to get SSIS to see that you want the Excel data to be numeric. Try this:
- format the cells in the sheet and save.
- edit the SSIS Excel destination
- in the Mappings tab hover your mouse cursor over the destination column that is supposed to be numeric. Look at the tool tip to see if it's showing a numeric data type.
bobs
2010-08-03 22:14:09
Thanks for this. I did try that but when I hovered over the mappings in SSIS it was still showing string. I did find another way, which was to create a row below the column headers with (dummy) numeric values (e.g. zeros). This does trick SSIS to identify these columns as numeric and exports the data below this row in the right data types. Probably not the best way, but works for me.
Kymmie
2010-08-05 09:11:09