Attunity provider for SQL Server 2019

Question

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

Answer 1

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

Answer 2

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.

Answer 3

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

Answer 4

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

Answer 5

Thank you all. We installed CU11 and it worked.

Cheers
Jim