Unable to run SSIS package under sql agent job
Hi,
I've created a new SSIS package and am trying to run it as a sqlagent job. If I 'Run as' the 'SQLSERVER AGENT' account I get'Executed as user: domain\administrator. The package execution failed. The step failed'. If I change this to 'Run as' 'sql agent service account' I get the following message'Executed as user: [[servername]\SYSTEM. The package execution failed'. The step failed.
I can successfully run the package in visual studio, management studio and via the command prompt.
Presumably it is a permissions problem? I've tried setting up the logging but nothing was written to the log when I run the job, there is otherwise(via Visual studio). I've also tried the followinghttp://support.microsoft.com/kb/918760, but it made no difference.
Anybody else experienced anything similar?
Thanks,
Paul

