Home Forums SQL Server 2008 Working with Oracle Cannot convert between unicode and non-unicode string data types RE: Cannot convert between unicode and non-unicode string data types

  • Hi, Could someone tell me how to resolve this issue.

    I changed my oracle source database from 9i to 11g.

    Everything worked fine earlier.

    But I get the following error now

    Code: 0xC02020F6 Source: Load Audit_Log ViewPoint xxxTable_Namexxx Source [1] Description: Column "xxxColumn_Namexxx" cannot convert between unicode and non-unicode string data types. End Error

    ***Followed by all columns***

    I believe it is the 64bit issue.

    I am running the job from SQL Server Agent.