I am extracting data from a 'Select * from MyTable' to an Excel file.
Some of the columns are numbers but when extracted to Excel are stored as character fields with the green triangle in the top left of each column cell.
I can of course manually convert the columns by going into Excel using 'Text To Columns' to change them to 'General' but is there a way of doing this in SSIS
using the Data Conversion or Excel destination options? I have fiddled about with them for a while and can't find a way of doing it.
I think it is probably more of an Excel limitation than an SSIS issue.
Dazed and confused.
Remember.. 'Depression is just anger without enthusiasum'.
Some of the columns are numbers but when extracted to Excel are stored as character fields with the green triangle in the top left of each column cell.
I can of course manually convert the columns by going into Excel using 'Text To Columns' to change them to 'General' but is there a way of doing this in SSIS
using the Data Conversion or Excel destination options? I have fiddled about with them for a while and can't find a way of doing it.
I think it is probably more of an Excel limitation than an SSIS issue.
Dazed and confused.
Remember.. 'Depression is just anger without enthusiasum'.