question

Anne-0140 avatar image
0 Votes"
Anne-0140 asked CeesV-0269 commented

DtExec tool not working

I have SQL server 2019 installed on a server, and I would like to run the dtexec.exe, I cannot find anywhere in the start menu,

so I go to this path: D:\Program Files\Microsoft SQL Server\150\DTS\Binn and find the dtExec.exe, when I click and tried to run it, it shows the black screen of command window and then disappeared.

I also tried in the program files(x86) it is the same, also tried the dtutil.exe, same thing, it blinks and disappear right away after clicking it.

How to fix this, thanks!

sql-server-integration-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Seems like you do not know some needed terminology. With UI some people mean a non-graphical user interface - where the opposite is Graphical User Interface (GUI). It is known under many names: DOS-prompt, CLI (command line interface), command window.
You first have to open a cmd.exe window and need to have navigation skills to get to the right folder. Or dtexec has to be in your Path environment variable. But if you do not know of these DOS-based tools and using CLI, you are far from home.

0 Votes 0 ·
YitzhakKhabinsky-0887 avatar image
0 Votes"
YitzhakKhabinsky-0887 answered YitzhakKhabinsky-0887 edited

Hi @Anne-0140,

(1) You can launch DTExecUI.exe utility. It has UI inteface. It will allow you to construct a command line for the DtExec.exe utility with all its parameters.
Please see its screen shot below.

Its location on my machine (for SQL Server 2017):
c:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\DTExecUI.exe

You probably would need to navigate here:
c:\Program Files (x86)\Microsoft SQL Server\150\Tools\Binn\ManagementStudio\DTExecUI.exe

But why bother?

(2) It is much better to deploy SSIS packages in a Project deployment mode to SSIS Catalog, and launch packages from there.


99614-ssis-dtexecui-2021-05-25-183653.png



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Anne-0140 avatar image
0 Votes"
Anne-0140 answered Anne-0140 commented

My question is how to launch dtexecUI.exe, I go to the directory, and when click it opens a command prompt, and then flash and closes it. The UI never shows like a UI interface

For my question here is using package model, not project model.
Thanks

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Please share a screen shot that shows DTExecUI.exe on the file system.

I updated my answer with the location of the DTExecUI.exe on the file system. It is a completely different location from the DtExec.exe


0 Votes 0 ·
Anne-0140 avatar image Anne-0140 YitzhakKhabinsky-0887 ·

Thank you, from your answer I got it is from the installation path of sql server management studio.

Here is the path on my computer:
D:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\Binn\DTexecUI.exe

That is deeply embedded.

Thanks much!

0 Votes 0 ·