SSIS package error

Currently in my org there is some migration activity going on from sql 2012 to 2016.
So currently there is a need to upgrade the excel sheets from .xls format to .xlsx format since our target server is 64 bit.
I am only facing issue for one spreadsheet and it is for a specific column which contains null value and few other values like 3,5.
Whenever the source excel is of .xls format the package execution is successful as when i preview them the blank cells are coming as null
but when i am converting that to .xlsx format and i am previewing that column value the null values are coming as blank and the package execution
is getting failed with below error :

The column status returned was: "The value could not be
converted because of a potential loss of data.".


Appreciate any help on this.

Are you staging this excel data into a staging table first before processing?

No i didnot change anything in the dataflow.The source is excel file and finally it loads into a table and we dont have any staging table.The real problem is it is not giving issue for .xls version but when i convert this to .xlsx the package is getting failed.