Post reply

errormessage:cann't convert between unicode and non unicode data types

  • February 16, 2012 at 1:45 pm

    #255772

    i am trying transform data from flatfile to xcel file, and i did change the data type at source level which is flat file to string data type but in xcel destination i am getting the error as shown above. i did try to use data conversion and derived column to convert data type but still facing same error need help please:)

    i am trying out this one in ssis 2008r2 where i manually created the flat file and want to transform it in to xcel

    thank you.

  • February 16, 2012 at 11:23 pm

    #1448278

    In the derived column, what expression did you use?

    When you convert a column in the data conversion component, it doesn't convert the actual column, but creates a copy that contains the converted values. Make sure you did the correct mapping in the destination.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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