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

Yitzhak Khabinsky 26,201 Reputation points

2024-01-16T21:44:52.37+00:00

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.
Please sign in to rate this answer.
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 26,201 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 26,201 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 26,201 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.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
ZoeHui-MSFT 38,621 Reputation points

2024-01-17T08:15:17.3933333+00:00

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.
Please sign in to rate this answer.
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?
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Olaf Helper 45,366 Reputation points

2024-01-17T09:24:56.8633333+00:00

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.
Please sign in to rate this answer.
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.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Gelin, Igor 0 Reputation points

2024-01-17T13:57:06.8066667+00:00

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""
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
ZoeHui-MSFT 38,621 Reputation points

2024-01-18T01:57:32.23+00:00

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.
Please sign in to rate this answer.
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
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

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

5 answers

Your answer