Script Task:Error: Could not load file or assembly 'Oracle.DataAccess, Version=2.112.1.0

lonely wolf 21 Reputation points
2020-09-14T04:19:22.243+00:00

Hi All,

I create a SSIS C# Script task to pull data from oracle server. I'm using default "Oracle.DataAccess,.DLL" from oracle 11g 32 bit. when i run that package normally its work fine. but after deploy package in SSIS DB package not working any more. I run GAC DLL install with DLL file but still its end with and error.

"Script Task:Error: Could not load file or assembly 'Oracle.DataAccess, Version=2.112.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified."

Can you please let me know what i need to do to solve this issue?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,575 questions
0 comments
Accepted answer
  1. Monalv-MSFT 5,901 Reputation points
    2020-09-14T06:09:03.27+00:00

    Hi @lonely wolf ,

    May I know if you choose 32-bit runtime when executing pacakge in SSISDB Catalog?
    24404-ssisdbcatalog32-bit-runtime.png

    Please refer to Could not load file or assembly for Oracle.DataAccess in .NET.

    Best Regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.
    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 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. lonely wolf 21 Reputation points
    2020-09-14T06:15:46.883+00:00

    Thanks. I wasn't aware that we can run ssis from SSIS DB 32 bit. its work fine now.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.