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 2 years, 6 months 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.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • 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 3 (of 3 total)

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