I have a little DTS problem here.
This package is programmed in an SQL Server v7.0 box and it executes OK when I run it manually.
The problem starts when I want to schedule the automatic execution of the DTS and in the Job History I got this error: "Non-SysAdmins have been denied permission to run CmdExec job steps. The step failed."
That means that the user owner of the DTS must be a SysAdmin? The current role for the user is "Process Administrator" but not "System Administrator".
As I cannot give the user superpower in the server, do I have to recompile de DTS under other user that is System Administrator?