Hi all!
I have been using the new Microsoft Oracle Connector in SSIS packages since the 1.0.2 release. Performances are finally good and more or less equivalent to the "old" Attunity component. I call dtsx through the dtexec.exe utility distributed within the Integration Services in SQL Server 2019 Enterprise.
It has happened sometimes (rarely) that the execution of the package freezes and does not proceed, so I have to kill dtexec process and re-run the package. A rare occurrence is not a real problem in my case.
But, since I upgraded to the last version of Microsoft Oracle Connector 15.0.2000.69 the problem happens very often (more than 50% of all executions). Are other people experiencing the same issue?
@Microsoft support (Tim.Chen), can you please fix this issue?