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