I have a ssis package which imports an excel file.
My problem is SSIS is importing more rows than they are present in the excel file.
On investigating i found that additional rows are all NULL and they are they being picked up because the format of the column has persisted in the blank rows. (in this it is date)
Is there any fool proof way to avoid this? (other than manually clearing the format of the blank rows)