Attunity provider for SQL Server 2019

Jim Jim 21 Reputation points
2021-06-23T17:24:37.427+00:00

Hi Team,

We are using VS 20019 and SQL Server 2019. Our source is oracle so we are using attunity provider 64bit which is downloaded from the below link.

https://www.microsoft.com/en-us/download/details.aspx?id=58228

But getting the below error when running the package from Integration catlog.

" The SSIS runtime version 15.0.2000.5 is too low for this Oracle connector. Please install a newer version of SSIS (later than SQL Server 2019 RTM)."

Kindly suggest how to resolve the error. Let me know if you need more details.

Cheers
Jim

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,361 questions
0 comments No comments
{count} votes

Accepted answer
  1. AmeliaGu-MSFT 13,971 Reputation points Microsoft Vendor
    2021-06-24T02:54:46.437+00:00

    Hi JimJim-6383,

    Welcome to Microsoft Q&A.
    Please try to install the latest CU for SQL Server 2019 as others mentioned. Microsoft Connector for Oracle does not support the version lower than 15.0.4003.23 (CU 1 for SQL Server 2019) in SQL Server 2019.

    Best Regards,
    Amelia

    0 comments No comments

4 additional answers

Sort by: Most helpful
  1. Guoxiong 8,201 Reputation points
    2021-06-23T17:38:54.193+00:00

    I guess that you have the SQL Server 2019 RTM. You can run SELECT @@VERSION to check the version. If it is RTM, you need to install the SQL Server 2019 CU1 based on the information from the link you provided.

    1 person found this answer helpful.
    0 comments No comments

  2. Yitzhak Khabinsky 25,731 Reputation points
    2021-06-23T20:20:25.087+00:00

    Hi @Jim Jim ,

    • No need in Attunity driver anymore. Microsoft has its own Oracle Connector for SSIS. SQL Server 2019 onwards. Your link correctly points to it.
    • It is better to install the latest available SQL Serve 2019 CU. Which is already CU11. Check it out here: sqlserverbuilds
    0 comments No comments

  3. Olaf Helper 43,246 Reputation points
    2021-06-24T05:34:19.51+00:00

    The SSIS runtime version 15.0.2000.5

    See at the link you posted => Details: Microsoft Connector for Oracle does not support the version lower than 15.0.4003.23
    Latest CU is version 11 = build 15.0.4138.2

    https://support.microsoft.com/en-us/topic/kb5003249-cumulative-update-11-for-sql-server-2019-657b2977-a0f1-4e1f-8b93-8c2ca8b6bef5

    0 comments No comments

  4. Jim Jim 21 Reputation points
    2021-06-28T08:11:12.357+00:00

    Thank you all. We installed CU11 and it worked.

    Cheers
    Jim

    0 comments No comments