CODEWITHSUNDEEP
.netsql-serverunicodessisoracle11g
user968441
user968441

Reputation: 1471

SSIS Package Error - cannot convert unicode to non unicode

I am new in SSIS Package development. Since few days I am facing an unexpected issue with SSIS package.

My SSIS Package is developed with using two different database. In Source, I have used SQL Server and Oracle and in destination I've used Oracle. SSIS Package was working as expected since few years but one of my client upgraded his server from 32bit to 64bit operating system.

Issue is with using Oracle database. Earlier, I was using MSDORA.1 for connectivity of Oracle database but one of Microsoft forum, I read that they've not launched MSDORA.1 yet. So I have to convert my SSIS package with OraOELDB.Oracle.1 drivers. Everything is working as expected in one of the server but when I deployed on client's server it is giving me below error.

<<MY_COLUMN>> cannot convert unicode to non-unicode string data types

I had VARCHAR2 data type in all columns of Oracle database table.

Upvotes: 2

Views: 6092

Answers (1)

mikey
mikey

Reputation: 5160

I have experienced the same when changing drivers. The OLEDB drivers for Oracle will give you "DT_WSTR" types in your SSIS. Some other drivers (e.g Attunity) will give you "DT_STR" types for the same fields.

You need to add a step to your SSIS Package that converts those fields to the "DT_STR" data type. You need to convert or cast. This thread contains more information for you: SSIS Package: convert between unicode and non-unicode string data types

Upvotes: 5

Related Questions