Post reply

Excel Destination - cannot convert between unicode and non-unicode

  • August 14, 2009 at 8:12 am

    #1039384

    The [Order Date] column is being read as non unicode.

    You could cast it to unicode in your select statement

    e.g. SELECT CAST([Order Date] AS NVARCHAR(20)) AS [Order Date]

    FROM MyTable

    Ideally though, especially where dates are concerned, you should preserver the datetime datatype where you can. In other words the source column should be DATETIME column and the excel column should be a DATE format too. This should help you avoid the regional/locale issues that rear their head so often in ETL.

    HTH

    Kindest Regards,

    Frank Bazan

  • February 1, 2016 at 1:18 am

    #1855621

    [font="Verdana"]

    Or even what you can try is, making a use of "DATA CONVERSION" Transformation. In a Data Conversion Transformation Editor, change the Data Type, i.e. String [DT_STR] TO Unicode String [DT_WSTR]. It worked for me.

    Mahesh[/font]

    MH-09-AM-8694

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

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