Hello All
I developed a SSIS package in visual studio 2019, everything worked perfectly until I had to read some data from an oracle DB, I connected to the Oracle DB with an ODBC source , from there package resulted in error in execution, by searching the errors, I found out that the 64BitRuntime should be false, trying this solution I didn't get any errors but the execution took forever and it couldn't even read a 9 row table from the Oracle DB. I started asking some of my colleagues and they said they run their package in 2017 version and it works fine, so I tested it in 2017 version and it executed without any problems so here is my first question
1. what changed from SQL server 2017 to 2019 that caused this error, or is the problem at the other end with oracle DB
after executing the package and resulting in success I created a SQL server 2019 agent job with the package. the job wouldn't execute and resulted in failure. by searching the errors found out the 32 bit runtime item should be checked, By doing so the problem was not solved and the same error would occur, having the same experience with VS2019, I created the job n SQL server 2017 and it worked just fine so here is the 2nd question
2. What is causing this, and is there a solution to run the job in SQL server 2019
the oracle database version is:
Oracle Database 11g Enterprise Edition Release 11.2.1.0 - 64 bit production
by the way ,I don't have access to this DB and I Can only access the views they made for the job .