Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSIS 2008 To Excel Number Columns Without Green Triangle In Top Left Of Each Cell

Status
Not open for further replies.

Skittle

ISP
Sep 10, 2002
1,528
US
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'.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top