can not extract data from a DB in ORACLE in SSIS

Daniel Ribera 21 Reputation points
2022-04-07T19:52:51.78+00:00

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
    2022-04-08T06:08:26.443+00:00

    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.


0 additional answers

Sort by: Most helpful