Decimal points issue while working with Excel Source @SSIS

Issue: In SSIS if you use Excel source in Data flow and if you have column in your excel file with decimal points then sometime during SSIS import fetched decimal values from excel are different from actual decimal values.

E.g In Excel, Amount column has 19.31 then while doing SSIS import, it will fetch 19.30000009.

Solution:

-Try to use Jet Oledb provider in place of Excel source

- Also provide EXTEND PROPERTIES value as "EXCEL 8.0;IMEX=1" in Jet Oledb provider.