These SP's will create scripts that create roles, allocate permissions the add users to roles.

IF EXISTS (SELECT name FROM sysobjects

      WHERE name = 'spScriptRolePermissions' AND type = 'P')

 BEGIN

     DROP PROCEDURE...

Yep, that clears it all up.

Thanks alot for your help.

Cheers, I've granted exec permissions to xp_cmdshell to all applicable users as well as the proxy account. Which has worked.

Thanks alot.

I have a question though, if a user have been...

As the package runs fine straight from DTS, go to services and find the logon for SQLServerAgent and ensure the logon has sufficient rights.

I had a similar problem a while back. The SQLServerAgent had domain administration rights. But certain jobs would seem to lock up. Investigations revealed that SQLServerAgent likes to run everything...