hi,

the data which is coming from excel is not an unicode format!

by default size would be around 255 char;

so go with the same conversion component, for eg.,

integer--> four byte signed int, like that we have to mention

for strings--> str[4 byte], like that choose the best format which you can find as the suggesion in the error component!

otherwise do the reverse thing, change the data type in dbo.table;

made easy:)