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?
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.