SSIS_DTExecUI.exe_In_2019

 1 DTExecUI.exe

1.1 Overview

1.2 How to connect

1.3 Not available in SQL Server 2019

1. DTExecUI.exe 

1. Overview

DTExecUI.exe is not a standalone executable; instead, it is a component of SQL Server Integration Services (SSIS), which is a part of Microsoft SQL Server. SSIS is a platform for building high-performance data integration and workflow solutions, and it includes tools for designing, debugging, managing, and running ETL (Extract, Transform, Load) processes.

DTExecUI.exe is related to the dtexec utility, which is a command-line tool used for managing and running SSIS packages. The "UI" in DTExecUI.exe stands for User Interface, indicating that it is likely a graphical user interface for dtexec. This UI can be used to configure and execute SSIS packages without using the command line directly.

The history of DTExecUI.exe would be intertwined with the evolution of SQL Server and SSIS. The tool itself may have undergone changes and improvements with each new version of SQL Server.

As of my last knowledge update in September 2021, the most recent version was SQL Server 2019. However, there may have been new releases or updates since then. If there have been significant changes or updates to SSIS or its components, you might want to check the official Microsoft documentation or release notes for the latest information.

2. How to connect 

Launch DTExecUI.exe:

You can find DTExecUI.exe in the following directory: C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Binn\DTExecUI.exe (replace "150" with your SQL Server version).

Alternatively, you can open it from the SQL Server Management Studio (SSMS) by connecting to the Integration Services, navigating to the "Stored Packages" node, and right-clicking on a package to run it.

3. Not available in SQL Server 2019

our SSIS packages to load in SQL Server 2019.  Turns out Microsoft doesn't include the DTExecUI.exe file with SQL Server 2019, but buries it in the SSMS folder.

This was the path: C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\Binn\DTExecUI.exe

Anyway, after we got that working, the DTS still wasn't loading the configuration file.  It turns out Microsoft has a registry bug.  So if any of your other clients ask about this in the future, here's how to fix it:

--Go to HKEY_CLASSES_ROOT\Applications\DTExecUI.exe\shell\open\command

--The default key is "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\Binn\DTExecUI.exe" "%1"

--You have to add an /F switch before the parameter: "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\Binn\DTExecUI.exe" /F "%1"

The configurations *should* load automatically after that, but if they don't, make these additional changes:

--Go to HKEY_CLASSES_ROOT\IntegrationServicesPackages.150

--If the "Shell" key doesn't exist, add it.  

--Change the Shell's key Default value to "Open"

--Add another key inside Shell called "open"

--Add another key inside open called "command" (so it'll be HKEY_CLASSES_ROOT\IntegrationServicesPackages.150\shell\open\command)

--Change the Default value of command to "C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\Binn\DTExecUI.exe" /F "%L"

And that should get it.