Home Forums SQL Server 2008 Working with Oracle Change of source databases(9i to 11g) 0xC02020F6 cannot convert between unicode and non-unicode string data types RE: Change of source databases(9i to 11g) 0xC02020F6 cannot convert between unicode and non-unicode string data types

  • August 16, 2012 at 12:42 pm

    #1526778

    You should not set the NLS_LANG to AL32UTF8 if the client (SQLSERVER varchar) isn't AL32UTF8 aware.

    Found a post that fixed this issue in SSIS apparently