can not extract data from a DB in ORACLE in SSIS

Daniel Ribera 21 Reputation points

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.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,485 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 34,576 Reputation points

    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.


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



    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.

0 additional answers

Sort by: Most helpful