I have excel file, I want to make Lookup on it and save the result to new table in database.
enter image description here

I have already tried to change data types in Excel Source from Uni-code to String in Advanced Editor, so it was the same datatype as in reference table for Lookup. Now is is showing error “column cannot convert between unicode and non-unicode”. Also I have set one column to float, because it is float in reference table, but when I try to map this columns in Lookup I still get this error:
enter image description here.
Any suggestions?
Thank you for help.