Post reply

cannot convert between unicode and non-unicode string data

  • June 20, 2011 at 9:13 pm

    #252217

    Hi !I am running a simple Query on a oracle source database as below and trying to insert the data to oracle destination with SSIS package. I even tried to use the data conversion between source and destination to [DT_STR] but still i was getting the error "cannot convert between Unicode and non-Unicode string data" can some one guide me here ??? Thanks in advance 🙂

    Query:-

    select sysdate, i.host_name, i.instance_name, d.name ,'ORACLE' as DB_Type, i.version, d.platform_name, 'NA' as PLATFORM_VERSION from v$instance i, v$database d

  • June 20, 2011 at 10:56 pm

    #1341602

    Try converting to DT_WSTR if the max length of your string is 4000 or less. If more then use DT_NTEXT.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • June 21, 2011 at 1:41 am

    #1341664

    Check the output column properties of under advanced editor for the data source , else use a data conversion under the transformation tab.

    DT_WSTR is for unicode.

    Jayanth Kurup[/url]

  • June 21, 2011 at 9:51 am

    #1341924

    Hi I even tried converting to DT_WSTR, but still its giving out error .

  • June 24, 2011 at 2:08 am

    #1343512

    What is the datatype of the source?

    What is the datatype of the destination?

    Also, be aware that using the conversion component doesn't actually convert the column, it rather makes a copy of that column with the converted values. So make sure you update your 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 5 posts - 1 through 4 (of 4 total)

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