DTExec is not working in xp_cmdShell

Hi All,

When I was trying to execute an SSIS package from DTExec using xp_cmdShell, it is giving an error message saying "unrecognized command,...". This error I am getting only in my Staging Environment. But at the same time, it is working fine with Development and Production servers.

I suspect the issue should be with config or access issues. So if anyone of you faced the same problem or if anyone have any solution, please share with me.

Thanks in advance for your help.

Thanks & Regards,

Prakash Srinivasan

Two things:
- Make sure you are using the full path to dtexec.exe.
- Is SSIS actually installed on the staging server?