January 30, 2026 at 6:39 pm
Hello all,
I am having one heck of a time installing Microsoft Connector for Oracle on a VS2019 instance with Integration Services 3.15 and also on VS2022 with integration services installed. For the life of me, I cannot get the Oracle connection manager to show up when I right click on the connection managers and do a new connection. I followed all the directions I found which was basically to install in this order:
I have done that along with a million other things but I still can't get that Oracle Connection Manager to show up. I am hoping someone else has some experience with this as we are looking to move away from the old unsupported Attunity Drivers that went away in June or July of 2025. I am in process of restoring my machine back to VS2019 with Integration Services 3.15 that is working just fine to hopefully attempt this upgrade again. Any help would be greatly appreciated!
January 31, 2026 at 7:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
February 3, 2026 at 4:14 pm
Probably a few dumb questions but:
1- did all of the installs succeed or did any give errors?
2- you installed the connectors on your local machine AND the server, correct? Local machine would be required for development, server would be required for deployment.
When you installed all that stuff, did you already have VS2022 installed? Did you install it into VS2022 or into VS2019?
I'd also make sure that you are using the latest Oracle connector and SSIS tools for VS2022.
Last thing, there are known limitations of the Oracle connector, one of them being that it can only be used as "The Microsoft Connector for Oracle can only be used by implementing an Oracle Source or Oracle Destination in a data flow task". Is that what you are doing? (source - https://learn.microsoft.com/en-us/sql/integration-services/data-flow/oracle-connector?view=sql-server-ver17)
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply