Using the latest version of VS2022 Pro, on both a clean install of Windows 10 and also Windows 11 I was able to reproduce the problem on two different windows installs.
C:\Program Files\Microsoft Visual Studio\2022\Professional\Common7\IDE\CommonExtensions\Microsoft\SSIS\160\Binn\DTSWizard.exe
This app fails to start after install with Event log showing:
Application: DTSWizard.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.IO.FileNotFoundException
at Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.Main(System.String[])
Faulting application name: DTSWizard.exe, version: 13.0.6300.2, time stamp: 0x610de848
Faulting module name: KERNELBASE.dll, version: 10.0.19041.3393, time stamp: 0x6b4de7c9
Exception code: 0xe0434352
Fault offset: 0x000000000002cf19
Faulting process ID: 0x2dc
Faulting application start time: 0x01da013864fd8173
Faulting application path: C:\Program Files\Microsoft SQL Server\130\DTS\Binn\DTSWizard.exe
Faulting module path: C:\WINDOWS\System32\KERNELBASE.dll
Report ID: 50a62eb9-5e46-44f4-82b4-b867a2e5e574
Faulting package full name:
Faulting package-relative application ID:
Microsoft.DataTools.IntegrationService File Version 16.0.5314.0
However if I uninstall and install the previous version that I had the installer for (File version 16.0.5223.0) it works and starts up ok.
This seems a pretty fundamental problem with this version. We use the Wizard multiple times a week for taking Excel into SQL. We have to use it from here as SSMS is 32bit and our office is 64bit which creates problems with the Microsoft.ACE.OLEDB.16.0 drivers. We can't have both versions installed as it say the 64 must be uninstalled first.. SSMS is only 32bit. I don't want to have to uninstall office each time I want to import an Excel file. The work around is to run the DTSWizard not from SSMS and it used to work.
Kind regards
Miles