DtExec.exe does not work

  • 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!

     

  • Do you run it from commandline?

  • Hi, this is correct behavior dtexec.exe is a command line tool to call ssis packages if you want GUI version DTExecUI.exe you should have it installed with SSMS  eg. C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\Binn\DTExecUI.exe

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply