Right-click on a dtsx package in windows explorer doesn't give an option of dtexecui

Question

Right-click on a dtsx package in windows explorer doesn't give an option of dtexecui

Gelin, Igor 0

Hi everyone, I installed SQL Server 2022 and all tools. Navigate to a dtsx package in windows explorer -> Right-click on the package -> got an option "Open with ..." -> "Windows can't open this type of file (.dtsx)". How can I make it work? Thank you.

Gelin, Igor 0 Reputation points

2024-01-17T13:51:32.8866667+00:00

Add a registry key. I attached the registry file. Change the extension from txt to reg before running the file. If you decide to add the key manually: Add the following registry key. Windows Registry Editor Version 5.00 [HKEY_CLASSES_ROOT\Applications\DTExecUI.exe] [HKEY_CLASSES_ROOT\Applications\DTExecUI.exe\shell] [HKEY_CLASSES_ROOT\Applications\DTExecUI.exe\shell\open] [HKEY_CLASSES_ROOT\Applications\DTExecUI.exe\shell\open\command] @=""C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\CommonExtensions\Microsoft\SSIS\160\Binn\DTExecUI.exe" /F "%1""

DTEXECUI_2022.txt

5 answers

Your answer

Gelin, Igor 0 Reputation points

2024-01-17T13:51:32.8866667+00:00

Add a registry key. I attached the registry file. Change the extension from txt to reg before running the file. If you decide to add the key manually: Add the following registry key. Windows Registry Editor Version 5.00 [HKEY_CLASSES_ROOT\Applications\DTExecUI.exe] [HKEY_CLASSES_ROOT\Applications\DTExecUI.exe\shell] [HKEY_CLASSES_ROOT\Applications\DTExecUI.exe\shell\open] [HKEY_CLASSES_ROOT\Applications\DTExecUI.exe\shell\open\command] @=""C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\CommonExtensions\Microsoft\SSIS\160\Binn\DTExecUI.exe" /F "%1""

DTEXECUI_2022.txt

Answer 1

ZoeHui-MSFT 41,551

Hi @Gelin, Igor,

When SQL Server 2022 Integration Services (SSIS) is installed on a machine that has SQL Server 2005 Integration Services (SSIS) or SQL Server 2008 Integration Services (SSIS) installed, multiple versions of the dtexec utility are installed.

To ensure that you run the correct version of the utility, at the command prompt run the utility by entering the full path (<drive>:\Program Files\Microsoft SQL Server**<version>**\DTS\Binn).

Regards，

Zoe Hui

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

Gelin, Igor 0 Reputation points

2024-01-18T13:17:32.41+00:00

Hi Zoe Hui, The machine has SSIS 2012, 2016, and 2022 installed. They all should work for the appropriate version of dtsx files. DTEXECUI that found here "C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\CommonExtensions\Microsoft\SSIS" is not in the path (<drive>:\Program Files\Microsoft SQL Server**<version>**DTS\Binn)*. Why was it installed in "C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\CommonExtensions\Microsoft\SSIS" and why it doesn't work? Sincerely, Igor

Answer 2

Gelin, Igor 0

Add the following registry key. Windows Registry Editor Version 5.00 [HKEY_CLASSES_ROOT\Applications\DTExecUI.exe] [HKEY_CLASSES_ROOT\Applications\DTExecUI.exe\shell] [HKEY_CLASSES_ROOT\Applications\DTExecUI.exe\shell\open] [HKEY_CLASSES_ROOT\Applications\DTExecUI.exe\shell\open\command] @=""C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\CommonExtensions\Microsoft\SSIS\160\Binn\DTExecUI.exe" /F "%1""

0 comments

Answer 3

Olaf Helper 47,616

Have you installed SSIS at all? It's an optional component and by default not selected during installation of SQL Server. Or have you may installed the free Express Edition? SSIS isn't a supported feature of Express.

Gelin, Igor 0 Reputation points

2024-01-17T13:13:48.1033333+00:00

Yes, I installed SSIS.
Gelin, Igor 0 Reputation points

2024-01-17T13:14:18.2133333+00:00

Yes, I installed it.

Answer 4

ZoeHui-MSFT 41,551

Hi @Gelin, Igor,

To run an Integration Services package, you can use one of several tools depending on where those packages are stored. The tools are listed in the documentation.

Also you may check Execute Package Utility (dtexecui)

Regards，

Zoe Hui

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

Gelin, Igor 0 Reputation points

2024-01-17T13:22:35.3333333+00:00

Hi Zoe Hui, I've found dtexecui.exe in two places: C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\CommonExtensions\Microsoft\SSIS\160\Binn

and

C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\CommonExtensions\Microsoft\SSIS

The latter doesn't work. The former works. Why is it in two places? What's the purpose of the latter?

Answer 5

Yitzhak Khabinsky 27,116

Hi @Gelin, Igor, (1) First, you should launch the DTExecUI.exe on its own. On my machine it is in the following location: c:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\CommonExtensions\Microsoft\SSIS\160\Binn\DTExecUI.exe Just after that you need to specify what SSIS package to launch. (2) Overall, it is better to deploy SSIS Projects to Integration Services Catalog. Please see below. ssis-database-and-catalog

Gelin, Igor 0 Reputation points

2024-01-16T21:52:14.5466667+00:00

Hi Yitzhak, The packages reside in file system. In SQL Server 2016 it worked fine. Why is it broken in Windows 11 and SQL Server 2022? I'd prefer to open a package in windows explorer with right-click. It's not convenient to navigate to dtexecui and then navigate to a package.
Yitzhak Khabinsky 27,116 Reputation points

2024-01-16T21:59:56.5+00:00

@Gelin, Igor, Please see a second part in my answer, (2) Overall, ... SSIS packages on the file system belong to the obsolete SSIS circa 2005 - 2008R2.
Gelin, Igor 0 Reputation points

2024-01-16T22:05:16.8366667+00:00

Well, the packages are in file system, they are not in the catalog.
Yitzhak Khabinsky 27,116 Reputation points

2024-01-16T22:09:45.57+00:00
You have two options:

Change Windows 11 settings to associate DTExecUI.exe with .dtsx files.
https://answers.microsoft.com/en-us/windows/forum/all/change-default-app/a425e784-0e48-4fa5-93e8-c7f08b47c324

Deploy SSIS Projects to the Integration Services Catalog.
Gelin, Igor 0 Reputation points

2024-01-16T22:25:15.2+00:00

#1 Is not so easy to implement.
Yitzhak Khabinsky 27,116 Reputation points

2024-01-16T22:59:09.9033333+00:00

By the way, I am using SSMS v.19.3. That's why c:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\CommonExtensions\Microsoft\SSIS\160\Binn\DTExecUI.exe May be you machine has that file in a different location.
Gelin, Igor 0 Reputation points

2024-01-17T13:20:57.9366667+00:00

Indeed, dtexecui.exe is in two places: C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\CommonExtensions\Microsoft\SSIS\160\Binn and C:\Program Files (x86)\Microsoft SQL Server Management Studio 19\Common7\IDE\CommonExtensions\Microsoft\SSIS The latter doesn't work. The former works. I'll ask ZoeHui about the utility found in two locations.

Share via

Right-click on a dtsx package in windows explorer doesn't give an option of dtexecui

5 answers

Your answer