Hi, I am facing problem while loading excel in database using SSIS, for one of the alphanumeric column NULL values are loaded.
I read earlier blogs on this issue as SSIS scan only first 8 rows and apply datatype based on it.
AS a workaround : I have addded IMEX=1 in excel connection string/
and updated TypeguessRows property value to 0 in registry still no luck.
Error seems there, can anyone help me on this.