job failed (SSIS). Executed as user: SRVDESASQL2005\SYSTEM.

Hi everyone,

I've made SSIS using domain security and after that it has been scheduled by Sql Server Agent. But that job fails and looking into history job I read:

"Executed as user: SRVDESASQL2005\SYSTEM. The package execution failed. The step failed."

Mssql Server agent is being used for local system. Is there the problem?

Nevertheles the aforementioned user have sysadmin role.

Does anyone ever faced this kind of issue?

Thanks in advance,

Check out this kb article, which digs into scheduling and permissions problems, and the way to troubleshoot them:

http://support.microsoft.com/kb/918760

|||

Effectively I was setting local system as user for the service so that...

Thanks anyway.