Forum Discussion

LarryZ3's avatar
LarryZ3
Copper Contributor
Jan 15, 2024

Visual Studios 2022 SSIS package upgrade error "Object reference not set to an instance of an object

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:

  1. Microsoft.DataTools.IntegrationServices.exe   version: 1.3.2
  2. SSMS-Setup-ENU.exe   version:19.3
  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.

No RepliesBe the first to reply

Resources