1. We have input excel sheet having column data like
Col1 Col2 Col3
M1 100
M2 200
M3 300 0.32
If we do the import of above sheet data in sql table using ssis
the data in sql table is coming like ( the Col3 data missing or coming as null )
Col1 Col2 Col3
M1 100 NULL
M2 200 NULL
M3 300 NULL
Why it is coming as NULL for M3?
Table for all col1,col2,col3 datatype is nvarchar(255)