meera desai
asked on
How to handle Excel column that contain null value while loading in SQL server using SSIS ?
Hello ,
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
meera desai, I know is your first post here in EE but it would be good if you could give some feedback to the Experts that already spent their time trying to help you.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.