Burninator (12/23/2011)
I think it's jsut the way that Excel handles a variance in data type within a column. your first few rows make Excel think you have a text data type, then up pops a number type. It provides the green triangle as a warning that a potential number field is being treated as text.
That is what happens if you load Excel from SSIS.
Currently several of the Worksheets are populated from another Worksheet and the green arrow warning does not appear.
I'm trying to find a work around to this issue.:w00t:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/