SSIS Job failing

  • I tried to schedule SSIS packages which are failing for reasons I do not understand.

    After I deploy the SSIS packages to the Server using , I am able to see those packges in SSIS and even manually run them successfully. However, when I schedule them to run they keep failing.

    I am scheduling them as a different user who has sysadmin server role.

    I have set the SQLAgentOperatorRole,SQLAgentReadRole,SQLAgentUserRole on the MSDB database.

    I do not know if I am setting the options which are required or just an overkill.

    One more thing which is intriguing is, even though I deploy the project to MSDB, even though the project deploys successfully, I do not see the list of packages under MSDB database.

    Can somebody guide me with the correct steps on this.

  • What error messages are you getting?



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • For some strange reason, the job decided to run today. so no issues.

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

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