in SSIS, i tried to read a cell from Excel source, the figure is 5.15600339929586, Excel formatted it with 1 decimal place which gives 5.2. I want to read the actual figure 5.15600339929586 instead. How to do it? I found the actual figure 5.15600339929586 can be imported when the excel file is being opened, but SSIS reads the formatted figure (5.2) when the source excel file is closed. Please kindly advise, thanks !

can you set the property of that column in Excel to decimal 10 or what ever number you want after excel. Right Click on column -->Format cell-->Number--Decimal Places. than try it...hope this should work. Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

thanks for your answer, but the source data comes from different sources and aren't predictable, and manual work isn't allowed. Have to find a way to solve it without human work.

can you let me know the datatype which SSIS displays in Excel source? As even i tried the same and exce source in my case was considering float as datatype and correct value is considered.

in excel, format is number to decimal places 1 in SSIS, i read it as OLE DB source itno recordset destination, output from oledb source as 'DT_WSTR' someone got a similar problem and sounds it is like an oledb behaviour http://efreedom.com/Question/1-2045611/Excel-OleDb-Shows-Numbers-Differentlydepending-Whether-Spreadsheet-Open many thanks !