Bug in DataTools.IntegrationServices 1.2 - DTSWizard will not start System.IO.FileNotFoundException

Miles Forrest 0 Reputation points
2023-10-17T21:48:52.8+00:00

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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,467 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 33,626 Reputation points
    2023-10-18T08:48:33.1366667+00:00

    Hi @Miles Forrest,

    We can't have both versions installed as it say the 64 must be uninstalled first.

    Check this blog which could solve the issue Installing the Microsoft.ACE.OLEDB.12.0 Provider for Both 64-bit and 32-bit Processing.

    To use the 64-bit version of the SQL Server Import and Export Wizard, you have to install SQL Server. SQL Server Data Tools (SSDT) and SQL Server Management Studio (SSMS) are 32-bit applications and only install 32-bit files, including the 32-bit version of the wizard.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments