Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Execute Package Utility (dtexecui) not installed after installing SQL Server 2017

I was not able to find Execute Package Utility (dtexecui) after installing SQL Server 2017. Was not able to find any standalone installer from Microsoft to install it as well. Will any one please guide me on installing it to run my SSIS Packages?

like image 608
CDD Gateway Avatar asked Oct 03 '19 04:10

CDD Gateway


1 Answers

I've just found the exact same issue.

I did check my path for DTExec and found it installed as part of SQL Server Management Studio 18 (18.3.1) in the following location along with DTExecUI:

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

Of course your install location may vary.

For reference, I found the program in different locations based on different version of Sql Server Management Studio

SQL Server MS 2014

C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\

SQL Server MS 17

C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\

(Edit) One final note, in my instance the dtsx packages didn't have any default application and i had to add the registry entries required to pass the parameters: This was mine:

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\IntegrationServices.Package.140\Shell]
@="Open"

[HKEY_CLASSES_ROOT\IntegrationServices.Package.140\Shell\Open]

[HKEY_CLASSES_ROOT\IntegrationServices.Package.140\Shell\Open\command]
@="\"C:\\Program Files (x86)\\Microsoft SQL Server Management Studio 18\\Common7\\IDE\\CommonExtensions\\Microsoft\\SSIS\\150\\Binn\\DtExecUI.exe\" /F \"%L\""

Once that was in place, using the default process to associate files with the application, dtsx files opened on the server with the correct parameters.

like image 164
Stu Wilson Avatar answered Nov 15 '22 00:11

Stu Wilson