December 8, 2011 at 6:35 am
Hi SSIS Experts,
I populate sever worksheets in a workbook from SQL Server.
All of the numeric columns in excel have a green arrow in the top right hand corner.
It interprets it as a text field and it gives you the option of clicking on each cell and convert to a number.
I have attached Sample output.
It list the following as action to be taken and I have done all of that and a lot more.
I have CAST as a INT. Set the Data Types in the Data Conversion Task to a signed integer, formatted the Excel columns as numeric.
I'm having no luck.:crying:
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/
December 8, 2011 at 9:53 am
Any ideas?:hehe:
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/
December 8, 2011 at 3:35 pm
I had the same problem with the phone & fax fields until I formatted them as (XXX) XXX-XXXX.
Any ideas would be greatly appreciated.
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/
December 9, 2011 at 7:14 am
Why is there an entire Excel manual in your post? I'm not really going to be bothered by reading it all...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 9, 2011 at 7:25 am
Koen Verbeeck (12/9/2011)
Why is there an entire Excel manual in your post? I'm not really going to be bothered by reading it all...
It is not exactly a manual but if you click to the right of a cell with an error it pops up the help text.
I removed it.
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/
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy