none
Error at Data Flow Task [Excel Destination [6804]]: Columns......cannot convert between unicode and non-unicode string data types. RRS feed

  • Question

  • I have tried making the columns dt_str and dt_wstr in the derived column editor but does not fix the error. I am trying to copy data from a table (ole DB Source) to an excel spreadsheet (Destination).  Changing the datatypes does not seem to make a difference. MSSQL 2008 R2.
    Wednesday, December 5, 2012 8:49 PM

Answers

All replies

  • Excel is not Unicode enabled application, so you just use the non-unicode

    Arthur My Blog

    Wednesday, December 5, 2012 9:13 PM
    Moderator
  • Excel file loading requires conversion instead of derived columns, See below link:

    http://www.mssqltips.com/sqlservertip/1393/import-excel-unicode-data-with-sql-server-integration-services/

    Regards,Eshwar.


    Regards,Eshwar -Please vote as helpful or mark as answer, if it helps

    Thursday, December 6, 2012 4:25 AM
  • I have tried using both derived column and data conversion and neither will work. Using the data conversion transform I get the error:
    Error at Data Flow Task [Excel Destination [790]]: Columns ".........." cannot converty between unicode and non-unbicode string data types.
    • Proposed as answer by Mark Saldi Friday, December 7, 2012 2:35 PM
    • Unproposed as answer by Mark Saldi Friday, December 7, 2012 2:35 PM
    Friday, December 7, 2012 12:36 PM
  • Hey make sure your data type is string(DT_STR) in data conversion. it should work.
    Friday, December 7, 2012 2:37 PM
  • Hi Carlje,

    Add Data Conversion transformations to convert string columns from non-Unicode (DT_STR) to Unicode (DT_WSTR) strings.

    Details about it, please see:
    http://msdn.microsoft.com/en-us/library/aa337316(v=sql.90).aspx

    Thanks,
    Eileen

    If you have any feedback on our support, please click here


    Eileen Zhao
    TechNet Community Support

    • Marked as answer by Eileen Zhao Friday, December 14, 2012 1:23 AM
    Monday, December 10, 2012 7:26 AM