Post reply

Unicode and Non Unicode String Data Type

  • January 29, 2007 at 8:32 am

    #115428

    Hi

     

    I backed up a table using Data Export Wizard to another database. Table has 3 int and 1 nvarchar(max) column. Nvarchar(max) contains XML.

    Now I wanted to pull back those data to another table [Using a view and the backend table is a compressed one using SQLCompress.net] using SSIS. But SSIS is throwing the following error:

    Column ‘Test’ can not be converted between Unicode and Non Unicode String Data Type.

    This error I faced even when I tried to use SSIS instead of Wizard to backup table also. Could any one please help how to resolve this issue?

    Thanks in advance.

     

    Regards

    Utsab Chattopadhyay


    CDBA

  • January 29, 2007 at 1:35 pm

    #686267

    I would use a dataflow task and then insert a data conversion task.. that will handle the conversion for you..

  • January 29, 2007 at 1:54 pm

    #686271

    Hi Rich

    Thanks for the response. Source is nvarchar(max) and destination is varbinary(max) [This is taken predefined by SQLCompress.net]

    Could you plz tell, what data conf. will I use for the output column in the Data Conversion Task? [Actually I tried it.. but for all common cases, it tells that the data type conversion is not allowed ]

    Thanks in advance.

    Regards

    Utsab Chattopadhyay


    CDBA

  • January 31, 2007 at 8:18 am

    #686866

    hmm, I set up couple tables with source and destination as what you described and did not have an error converting.. Perhaps there is something flaky with your compression? I dunno.. Sorry!

  • January 31, 2007 at 8:25 am

    #686868

    Ya Rich... I do guess the same. Perhaps SQLCompress.net is doing some thing which makes the data transfer also impossible.

    Anyway thanks a lot for you time. .

    Regards

    Utsab Chattopadhyay


    CDBA

Viewing 5 posts - 1 through 4 (of 4 total)

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