Microsoft Connector for Oracle is released for SQL Server 2019 Preview

Hi 

I can get the 'Microsoft Connector for Oracle' driver to work fine in Design View using an EZConnect connection string e.g: username/password@[//]host[:port][/service_name]

However I need to use the Connector and Oracle Source component ( componentClassID="Microsoft.SSISOracleSrc" ) programmatically in a Script Task as I have 50+ data flows (Oracle Source to SQL Destination) to create.

No matter what workarounds/variations I try the process always fails at the same point in code:

DataSourceInstance.AcquireConnections(vbNull)

with error "Exception from HRESULT: 0xC020801C"

"SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "%1" failed >with error code 0x%2!8.8X!. There may be error messages posted before this with more information on why the AcquireConnection method call failed."

In an error handler I can save the package at the point of error using:

Dim App As New Microsoft.SqlServer.Dts.Runtime.Application
App.SaveToXml

and I can see the Oracle Connection Manager and Oracle Source Component have been created OK and I can successfully connect to the Oracle Source:

I have tried the usually noted workarounds:

Project Properties - Run64BitRuntime

DataSourceComponent.ValidateExternalMetadata = False

but always the same point of failure?

I am using the latest version of SQL 2019 SSIS (15.0.4138)

Grateful for any help.