SQL Server Performance

ssis job failed

Discussion in 'SQL Server 2005 Integration Services' started by arkiboys, Nov 6, 2007.

  1. arkiboys Member

    Hi, I am trying to create a job to run a ssis package. The job fails. Looking at the history log, there is no proper information on why the job failed. It just says: The job failed. The job was invoked by user ... please note that the ssis package runs fine on it's own i.e. in the designer by pressing the run button. Thanks
    arkiboys, Nov 6, 2007
    #2

  2. techbabu303 New Member

    have you checked the package.log also ?
    Does the user have adequate previleges to run it as a job ?
    Cheers
    Sat
    techbabu303, Nov 7, 2007
    #3

  3. arkiboys Member

    This was to do with permissions.
    All ok now.
    Thanks
    arkiboys, Nov 7, 2007
    #4

  4. dineshasanka Moderator

    yes it is agent user permission issue.
    You need to give appropriate permission for sql server agent user
    dineshasanka, Nov 7, 2007
    #5

  5. satya Moderator

    .,... if it is not a part of sysadmin group.
    satya, Nov 8, 2007
    #6

Share This Page