Execute denied in xp_cmdshell

[Luigi]

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

[Todd C]

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

Post by Luigi
Hi,
in my stored procedure, that start the execution of a SSIS package with
The EXECUTE permission was denied on the object 'xp_cmdshell', database
'mssqlsystemresource', schema 'sys'.
How can I solve?
Thanks in advance.
Luigi