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


[1016 byte] By [PaulMonaghan] at [2007-12-22]
# 1
Paul Monaghan wrote:

I've also tried the following http://support.microsoft.com/kb/918760

So when you configured the package to do error logging as suggested in this KB, what error do you get?

MichaelEntin-MSFT at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Integration Services...
# 2
Much the same info as the KB, but a couple of examples. The CmdExec subsystem is really worth a go, as the Package Store File Permissions issue will not show up in regular SSIS logging, or the SQL Agent history, it really needs the CmdExec job step log.
DarrenSQLIS at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Integration Services...
# 3

Excellent, thanks very much, the cmdexec job step worked. I didn't think of this until after I posted.

PaulMonaghan at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Integration Services...

SQL Server

Site Classified