It is my first post in this group.
I am facing issue while loading data from excel to sql server using SSIS.
When excel file column contain null value then it throw error.
and another issue that it column contain mix data type like string and number it throw error.
so how to resolve that.
I don't have permission to change guessing row. so what is alternate way