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.".
[Excel Source ] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.
Appreciate any help on this.