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

unicode ssis oledb dataflowtask
FabioEnne picture FabioEnne · Jan 31, 2017 · Viewed 8.1k times · Source

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

Answer

Vijai Maurya picture Vijai Maurya · Nov 14, 2018

I have solve this issue by converting the data to varchar(max) while selecting from source table.

Related questions

SSIS Convert Between Unicode and Non-Unicode Error

I have an ssis package where I am using an OLEDB source linking to SQL Server 2005 table. All columns except a date column are NVARCHAR(255). I am using an Excel destination and using a SQL statement to create the sheet …

Read More
Import Package Error - Cannot Convert between Unicode and Non Unicode String Data Type

I have made a dtsx package on my computer using SQL Server 2008. It imports data from a semicolon delimited csv file into a table where all of the field types are NVARCHAR MAX. It works on my computer, but it …

Read More
UnicodeEncodeError: 'ascii' codec can't encode character u'\xa0' in position 20: ordinal not in range(128)

I'm having problems dealing with unicode characters from text fetched from different web pages (on different sites). I am using BeautifulSoup. The problem is that the error is not always reproducible; it sometimes works with some pages, and sometimes, it …

Read More