Search code examples
sql-servervisual-studio-2013ssisbidsdtexec

Package Source Path not populated while using DtExecUI.exe

I had SQL Server 2008 installed earlier. I had the ability to right click on any SSIS package and select Open With "SQL Server 2008 Integration Services Package Execution Utility" as an option to run the package standalone.

Recently, we upgraded to SQL Server 2014 and now I don't see this option when I right click. I browsed manually and located DtExecUI.exe to open with however Package Source is not being populated automatically (Screenshot attached).

Is there any work around for this ?

enter image description here

Solution

  • It requires a registry hack. We are on 2017 and experienced the same issue. The Package source and Package does not get filled in. I fixed it by tweaking the DTExecUI command registry key by adding a /F for file.

    At a command prompt, go to this registry key:

    HKEY_CLASSES_ROOT\Applications\DTExecUI.exe\shell\open\command

    Put a /F between the command and the "%1".

    "C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\DTExecUI.exe" /F "%1"

    Now it is filled in when you right click on a .dtsx and select "Execute Package Utility".