locked
Executed as user: <ComputerName>\SYSTEM. The package execution failed. The step failed. RRS feed

  • Question

  • Hi Everybody,

    Im Cuong from Vietname
    Im using SQL 2005 Server
    I have a database, it's TEST.
    and then, I create a new database, it's TEST_BACKUP
    I export from TEXT to TEST_BACKUP ,
    and create 1 SSIS package:
    Package name: Backup_package

    I run this package, it's ok
    but when i create a job to run this package , it's no ok.

    I see job history, sql server message:
    The job failed.  The Job was invoked by User sa.  The last step to run was step 1 (1).
    Executed as user: <ComputerName>\SYSTEM. The package execution failed.  The step failed.

    Please, Help me !!!

    Monday, May 3, 2010 10:14 AM

Answers

  • check the owner of the job.

    if domain account, change to sa or sql user name

    right click job name --> Job properties --> owner


    Mark as Answer If appropriate - SSS.Ezhil
    • Marked as answer by Tony Tang_YJ Monday, May 17, 2010 8:51 AM
    Monday, May 3, 2010 10:35 AM

All replies

  • check the owner of the job.

    if domain account, change to sa or sql user name

    right click job name --> Job properties --> owner


    Mark as Answer If appropriate - SSS.Ezhil
    • Marked as answer by Tony Tang_YJ Monday, May 17, 2010 8:51 AM
    Monday, May 3, 2010 10:35 AM
  • What is the Role of ComputerName>\SYSTEM. in the machine is it an ADMIN  ?

     

    FOR DBA activities u needs SA access and ADMIN OF the server machine to do it .

     


    Cheers , Varun
    Monday, May 3, 2010 12:04 PM
  • hi Ezhil,

    I too facing the same problem. but i followed all instructions which u mentioned yet i face the issue :(

    Any suggestions ?


    Wednesday, March 23, 2016 10:31 AM