October 22, 2022 at 4:55 pm
I need to convert our existing 2017 SSIS packages to 2019. Many of these connect to Oracle 19c dbs. In VS2017 we used the Attunity connector successfully.
I currently have VS2017 and VS2019 installed on my development machine to allow me to work through the conversion.
I have installed VS2019 with the required extensions and have 32 & 64bit Oracle drivers installed, but I do not have Oracle source and destinations in my SSIS toolbox. Neither do I have an Oracle connection option in my Connection Manager. I can successfully create connections to Oracle via ODBC and OLEDB but both of these options are problematic for our existing solutions.
I manually installed the MS Oracle connector (32 &64 bit) even though I understand that it should come with the VS2019 SSIS extension out of the box, but I'm still not seeing the connector in VS2019 as described in this article:
Any ideas on how to resolve this?
TIA
October 23, 2022 at 5:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
October 24, 2022 at 1:39 pm
Solution is to uninstall SQL Server Integration Services Projects v 4.2 and install 3.16 instead. 4.2 doesn't support the Oracle connector. Make sure you do a reboot after switching.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply