can not extract data from a DB in ORACLE in SSIS

Question

Good afternoon,
I have the following inconvenience from my Visual Studio 2019 doing an ETL, in SSIS doing a simple extraction from a DB in ORACLE I get the Error that it cannot do the transformation of Data from Unicode to NonCode, I have already tried in many ways as several tutorials indicate,

• placing a Data Conversion between the source and the destination, and placing the Data type in String(DT_STR)
• Changing in the advanced configuration, from the Output
• Install The Oracle Database Connector
• Update my version of SSIS.

And I keep getting that error, the strangest thing is that when I try on another PC doing exactly the same thing, even just bringing a single column, it happens without problems without the need for conversion, please help me if someone has experienced the same thing, I'll stay tuned Thanks a lot.

Answer 1

Hi @Daniel Ribera ,

It "works" on one server and not another could indicate different driver versions are behaving differently.

Here is a same thread you may take a reference to.

ssis-package-error-cannot-convert-unicode-to-non-unicode

You may change the validateExternalMetadata= "False" for a try.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.