Could not load file or assembly 'Microsoft.VisualStudio.Tools.Applications

Question

Dear all,

I have been following the SSIS Tutorial from Microsoft Learn up to the following:

https://learn.microsoft.com/en-us/sql/integration-services/lesson-6-4-deploying-the-lesson-6-package?view=sql-server-ver16

I am now stuck in step 8 of "Add the package to the SSISDB catalog" of the above link. The below is the error message I have shown:

System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.VisualStudio.Tools.Applications, Version=15.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.

File name: 'Microsoft.VisualStudio.Tools.Applications, Version=15.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'

at Microsoft.SqlServer.IntegrationServices.VSTA.VstaHelper.<CleanUp>b__31_0()

at Microsoft.SqlServer.IntegrationServices.VSTA.MtaExecution.Run(Action action)

at Microsoft.SqlServer.IntegrationServices.VSTA.VstaHelper.CleanUp()

at Microsoft.SqlServer.VSTAHosting.VSTAScriptingEngine.DisposeVstaHelper()

at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.MigrateVSTAFrom3To14()

at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PerformUpgrade(Int32 pipelineVersion)

at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostCheckAndPerformUpgrade(IDTSManagedComponentWrapper100 wrapper, Int32 lPipelineVersion)

WRN: Assembly binding logging is turned OFF.

To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.

Note: There is some performance penalty associated with assembly bind failure logging.

To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

I am completely new to SSIS and MSTA and I am now totally lost. Any help to resolve the error above is much appreciated.

Norman