DtExec tool not working

Question

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!

Answer 1

Hi @Anne ,

(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.

Answer 2

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