Unable to run SSIS package from Xp_cmdshell called from .nET Aplication

Question

I have a .net application from which I call a job in which I call a stored procedure which has the follwing command- EXEC xp_cmdshell 'dtexec /SQL "\DataLoadMasterPackage"' , no_output

On running the application nothing happens. No error as well.

On running package individually from the SSMS it is working fine.

Note : I have configured server to run xp_cmdshell I have tried running the execute statement from SSMS and it is executed without giving any error.

What can I be missing?

Answer 1

Hi please attach the error.

If the syntax is written is true, then I think your problem is permissions.