Post reply

PKG executed in job with error but not in debug

  • February 11, 2011 at 5:16 pm

    #142300

    Hi everybody, I have a package that when is executed in mode Debug dont show errors but when this is executed via job(scheduled), show me the error "Executed as user: CENCOSUD\lisarce. The package execution failed. The step failed."

    I don't know the reason, please I need your help.

    Thanks !

  • February 11, 2011 at 11:35 pm

    #1285991

    This might be due to access restrictions,

    in debug its running on your windows account,

    but after deployment it should be on Service or SQL Agent account...

    So if your package accessing restricted resources (Shared folder access or file writing/reading etc ) , that may be the problem.

    please verify and redaploy your pakage on a new account, or provide enough permission to your current account.

  • February 14, 2011 at 7:19 am

    #1286466

    The account of service SQL Server Agent and service SQL Server are running with my account network that have acces and all permissions of access(read, write, execute). I have to configure the service of SSIS with my account too?

  • February 14, 2011 at 10:58 pm

    #1286864

    In most of the cases,

    When you deploy and schedule a Package using SQL Agent Job, the package should be on the agent account,

    And normally its should be NTAuthority/NetworkService

    Please check that account has enough permission on your resources.

    By the way your package is accessing shared resources right?

  • February 15, 2011 at 9:12 am

    #1287136

    Thanks to everybody.

    The solution was that I change the target of file with the UNC of mapped unit.

Viewing 5 posts - 1 through 4 (of 4 total)

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