I am having problems trying to execute a DTS package from my stored procedure.
I have read the previous threads but am unable to get it to work.   My symptoms are exactly the same.  
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=17&messageid=148089
 
These are the steps I have followed:
1.  On the SQL Server box I went to services and set sqlServerAgent to logon as Administrator
 
Do I still need to add a user to the Administrators group under computer management?
 
Thanks