Post reply

Error executing job

  • March 26, 2008 at 2:59 pm

    #121180

    Hi everybody:

    I has create a package 'Export_Products' in my server PERU8\PERUEIGHT and run without errors, but when i execute the job with the unique step calling to this package show the following error:

    Message

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

    Why is the reason?

    Please, help me.

    Thanks

  • March 26, 2008 at 3:47 pm

    #794373

    It looks like a permissions issue. Make sure that the Peru8\SYSTEM account has permissions to do everything the package needs to do. When you ran the package outside of a job, it ran under the context of your user permissions. When you run it through the SQL Agent as Peru8\SYSTEM, it exectutes under the context of that user. Odds are that user does not have all of the permissions required to complete all of the tasks in the package.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • March 26, 2008 at 3:52 pm

    #794376

    Thanks Jhon by your answer. The solution was change 'Protection Level' from 'Encrypt sensitive data with user key' to 'Rely on server and storages and roles for acces control'.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply