SSIS Export Error: Column "***" cannot convert between unicode and non-unicode string data types

0
votes

I'm trying to export some data from SQL SERVER to EXCEL, with SSIS, and got error on all columns like

[Excel Destination [2]] Error: Column "Contact Id" cannot convert between unicode and non-unicode string data types.

I tried to change data type in the OLE DB Source to be 'Unicode string [DT_WSTR]' or 'Unicode string [DT_STR]', but I get same error no matter which one I use.

enter image description here

1
ssisexport
Possible duplicate of SSIS Convert Between Unicode and Non-Unicode Error - Nambu14
@Nambu12 Thanks. But in the issue you mentioned, he used NVARCHAR in sql, mine was from the table which has VARCHAR. Also, whether I tried convert of not ([DT_WSTR] or [DT_STR]) i got same error - ella
I used data conversion and now it seems to work. - ella

1 Answers

0
votes

try using data conversion task and data types as [dt_str] or [dt_wstr]