Running dtsrun from Stored Procedure

[ddrandy]

I am trying to run the following command from T-SQL and received an error. Can anyone tell me what this error means?

EXEC master..xp_cmdshell 'dtsrun /S SERVERNAME /N PKGNAME'

Error:
Msg 50001, Level 1, State 50001
xpsql.cpp: Error 87 from GetProxyAccount on line 604


Thanks

 

[mrdenny]

Either your SQL Server is running as the Local System Account, or the account that is running the stored proc doesn't have sa writes to the server. Or the settings for your proxy account are not set correctly, or are corrupt. Check BOL for xp_CMDShell for more info about the proxy account.

 

[ddrandy]

The user running the Procedure is not sa. But they do have execute rights on the xp_CMDShell SP. Can it only be run by a sa user?

Sorry, what is BOL?

Thanks

 

[mrdenny]

BOL is books on line. To use xp_CMDShell you have to be have the sysadmin role. There should be info in Books Online about how to configure the proxy account so that non-sysadmins can run xp_CMDShell.

Denny

--Anything is possible. All it takes is a little research. (Me)