question

JimJim-6383 avatar image
0 Votes"
JimJim-6383 asked JimJim-6383 answered

Attunity provider for SQL Server 2019

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-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GuoxiongYuan-7218 avatar image
0 Votes"
GuoxiongYuan-7218 answered

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

YitzhakKhabinsky-0887 avatar image
0 Votes"
YitzhakKhabinsky-0887 answered

Hi @JimJim-6383,

  • 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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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





5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JimJim-6383 avatar image
0 Votes"
JimJim-6383 answered

Thank you all. We installed CU11 and it worked.

Cheers
Jim

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.