Execute denied in xp_cmdshell

#1

Hi,
in my stored procedure, that start the execution of a SSIS package with
dtexec command, I receive this error:

The EXECUTE permission was denied on the object 'xp_cmdshell', database
'mssqlsystemresource', schema 'sys'.

How can I solve?

Thanks in advance.

Luigi

#2

I think it is a security feature that you need to enable at either the server
or database level. Check BOL.
--
Todd C
MCTS SQL Server 2005

"Luigi" wrote:

Quote:

Hi,
in my stored procedure, that start the execution of a SSIS package with
dtexec command, I receive this error:

The EXECUTE permission was denied on the object 'xp_cmdshell', database
'mssqlsystemresource', schema 'sys'.

How can I solve?

Thanks in advance.

Luigi

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Execute denied in xp_cmdshell

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Execute denied in xp_cmdshell - 12-10-2009 , 07:29 AM

RE: Execute denied in xp_cmdshell - 12-10-2009 , 07:59 AM