OraOLEDB.Oracle.1 issue

• a2zwd

  SSCrazy

  Points: 2353

  More actions

  November 1, 2012 at 8:32 am

  #284136

  Hi,

  I have created a SSIS package in BIDS 2008. I am importing data from oracle.

  Its working fine. Recently we upgraded to sql server 2012.

  When I opened the package in SSDT(BIDS 2010), I am getting errors at dataflow task's source. Error: Canot convert between unicode and nonnicode.

  What is the issue.

  My local machine is windows 2008 R2.

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  November 2, 2012 at 1:59 am

  #1555303

  The problem is that the OLE DB connection cannot convert unicode characters to non-unicode characters. (the error is quite self-explanatory)

  What is the datatype of the source?

  What is the datatype of the same column in the SSIS dataflow?

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