Search code examples
unicodessisoledbdataflowtask

SSIS Cannot convert between unicode and non unicode...but it's not true, how come?


I have a simple DTSX that takes in some data, and write it to a SQL server DB, on this DTSX execution it throws me some errors on some fields:

[OLE DB Destination [29]] Error: Column "mobile" cannot convert between unicode and non-unicode string data types.

But as you can see from the OLEDB DESTINATION COLUMNS MAPPING that's not true...how come?

enter image description here


Solution

  • I had this not a long time ago. In the connection manager I had 'Unicode' checked. After I found out it wasn't unicode, I unchecked it, but the OLE DB input in the Data flow task didn't update and I had to delete the input and create it again.