Home Forums Data Warehousing Integration Services SSIS inconsistent importing decimals from Excel spreadsheet RE: SSIS inconsistent importing decimals from Excel spreadsheet
Phil Parkin
SSC Guru
Points: 247210
More actions
July 26, 2013 at 8:49 am
#1636197
Could it be that formatting has been applied in Excel to display the value to 2 decimal places?
Try exporting from Excel to CSV and then using Notepad to see what's really there. Don't believe Excel:-)