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 symin role.
Does anyone ever faced this kind of issue?
Thanks in advance,This issue is already solved.
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''''s hard to provide information
without seeing the code. location: Alicante (ES)
"Enric" wrote:

> 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. T
he
> step failed."
> Mssql Server agent is being used for local system. Is there the problem?
> Nevertheles the aforementioned user have symin role.
> Does anyone ever faced this kind of issue?
> Thanks in advance,
>
>
>
>
>|||Just curious.. what was the reason. Was it because SSIS accessed some
resource in the network for whcih the local user didn't have access'
"Enric" wrote:
> This issue is already solved.
> --
> Please post DDL, DCL and DML statements as well as any error message in
> order to understand better your request. It''''s hard to provide informati
on
> without seeing the code. location: Alicante (ES)
>
> "Enric" wrote:
>

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.