Ole Db Destination Cannot Convert Between Unicode

Ole Db Destination Cannot Convert Between Unicode FAQ

How do i convert a non unicode source to a unicode table?

The problem of converting from any non-unicode source to a unicode SQL Server table can be solved by: add a Data Conversion transformation step to your Data Flow. open the Data Conversion and select Unicode for each data type that applies.

Why cant i convert data from ole db to excel?

Because you use SQL command to retrieve data for the OLE DB Source, and the SQL command includes CONVERT (VARCHAR (10),x_col), the Convert operation will fail as long as there are Unicode characters in the x_col column in the source table. When the x_col column has no Unicode characters, the SQL command runs successfully, so does the package.

What does this error at data flow task ole db destination mean?

Error at Data Flow Task [OLE DB Destination [23]]: Columns “firstname” and “FirstName” cannot convert between unicode and non-unicode string data types. What is this error? Excel data is usually stored in a Unicode format, but a database field can setup either be Unicode or Non-Unicode.

How to change datatype from dt_str to unicode string in ole?

If you right click on the OLE Destination and select "Show Advanced Editor" you have the option of changing the DataType from string [DT_STR] to Unicode string [DT_WSTR]. But once you click on OK it looks like the changed was saved, but if you open the editor again the change is gone and back to the original value.