Blog Post

SQL Server Integration Services (SSIS) Blog
3 MIN READ

Microsoft Connector for Oracle is released for SQL Server 2019 Preview

Tim.Chen's avatar
Tim.Chen
Icon for Microsoft rankMicrosoft
May 14, 2019
Microsoft Connector for Oracle  is the replacement of Attunity Oracle Connector starting from SQL Server 2019 and now it is released for preview. Microsoft Connector for Oracle provides compatibility...
Updated May 14, 2019
Version 1.0
Tim.Chen's avatar
Tim.Chen
Icon for Microsoft rankMicrosoft
May 13, 2020

Alexandru1190 is you are running in Visual Studio by default it will run in 32bit mode because Visual Studio is 32bit. If you also have SQL Server 2019 installed on the same machine then you can run in 64bit mode. You mentioned that you downloaded the 64bit connector, so I suppose you are running the package in 64bit mode, in which case it will launch the package with SSIS bits that came from the SQL Server 2019 installation. 

 

The version 15.0.2070.41 is the RTM version of SQL Server 2019. For the Oracle connector to work properly, it requires at least the CU1 (cumulative update) version of SQL Server 2019 to be installed. The latest one is already CU4 now. See https://support.microsoft.com/en-us/help/4548597/cumulative-update-4-for-sql-server-2019. Please upgrade your SQL Server installation to CU4 and try again.