I am getting the following error - "column "A" cannot convert between unicode and non-unicode string data types"

Question

I am following the SSIS overview video- https://www.youtube.com/watch?v=3cPq9FXk-RA I have a excel file that i want to import the contents from a SQL database. I created a oledb source file and excel destination. I am getting the following error -

"column "A" cannot convert between Unicode and non-Unicode string data types"

Please help what to do

Answer 1

You'll need to add a Data Conversion transformation to convert string columns from non-Unicode (DT_STR) to Unicode (DT_WSTR) strings because Excel only recognizes Unicode.

You need to do this for all the string columns.