I have an SSIS package created in Visual Studios 2017. It pulled data from SQL server 2016 and pushed it to Oracle. And it was password protected because of sensitive data.
I upgraded it to VS 2022 v17.8.4. and it now pulls from SQL server 2019.
I Installed the following to get passed some errors:
- Microsoft.DataTools.IntegrationServices.exe version: 1.3.2
- SSMS-Setup-ENU.exe version:19.3
- MicrosoftSSISOracleConnector-SQL19-x64.msi
I deleted this folder, but I can’t get passed the following error.
- When the error is "Object reference not set to an instance of an object.",
- delete the broken instance folder "%ProgramData%\Microsoft\VisualStudio\Packages_Instances<InstallationID>"
Any help would be appreciated.
