Post reply

Cannot Convert between unicode and non-unicode string data types

  • December 28, 2016 at 9:18 am

    #324698

    I"m trying to learn SSIS and am creating a package. I have a data flow with the following:

    1. OLE DB Source

    2. Data Conversion

    3. Excel Destination

    I"m unable to configure the Excel Destination. I'm getting a validation error - Columns... cannot convert between unicode and non-unicode string. I added the data conversion and for the DataType for the Output Columns I changed from Unicode string (DT_WSTR) to string (DT_STR). That did not work. I"m unsure what I'm doing wrong.

  • December 28, 2016 at 9:33 am

    #1919894

    Your conversion needs to be the other way around. Excel expects Unicode values, so you'll have to convert everything to Unicode coming out of your source (if it isn't Unicode already).

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply