SQL Server Performance Forum – Threads Archive
DTS xp_cmdshell errorHi, I have created a DTS package, which can be executed from EM, and also from the command prompt. But, when i put it under xp_cmdshell and run it in QA it fails.
It starts with the first step saying Loading, and then it gives NULL, and nothing happens.
I term served into that machine, and created that package. It is created in EM as my domain user account. I have given sa privillages to this account.
But, when I or other user executes, we uses sa account to execute it. c:>dtsrun /Sservername /Usa /P /Npackagename — runs fine exec master.dbo.xp_cmdshell ‘dtsrun /Sservername /Usa /P /Npackagename’ — does not work.
NULL It looks like some kind of permission issue, also, I dont know how to change the ownership of the package. Any help greatly appreciated. bill
Enable DTS package logging for information on execution of steps.
KBAhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074 to schedule a DTS package. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.