Post reply

SSIS - Oracle to SQL 2019 Standard error "Unexpected Termination"

  • June 28, 2022 at 3:45 pm

    #4056150

    I have a simple SSIS package where the source is oracle 12c Enterprise, with a destination SQL 2019 standard. When I run the package in 64bit on the server I get Unexpected Termination. When I go into the SQL job and set it to 32bit runtime it works fine. Any Ideas?

    Environments

    Source: Oracle 12c Enterprise

    Destination: SQL 2019 Standard

    Drivers Tried: Oracle InstantClient Basic Lite ODBC 19.15 & 21.6

    Note: Can't use Microsoft Connector because we are using SQL Standard.

    • This topic was modified 3 years ago by BTC100k.

  • June 28, 2022 at 3:51 pm

    #4056152

    This possibly means that there is a 32-bit version of the driver installed on the server but not a 64-bit version.

  • June 28, 2022 at 4:47 pm

    #4056174

    Thanks for your reply. I’m 100% sure I have it installed. When I go to ODBC 64bit under System DSN I can test connect with the 64bit drivers without a problem.

  • July 6, 2022 at 2:49 pm

    #4059634

    This is still unresolved. Any updates would be appreciated.  I have an open ticket with Microsoft too.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy