Post reply

Job Scheduling for SSIS Package

  • February 13, 2009 at 7:19 am

    #128408

    Hi Folks,

    Iam New To SSIS Packages. My Questions is Can we do job scheduling for SSIS Packages if so how? Please help me .

    Thanks

    Pradeep Kumar

  • February 13, 2009 at 7:54 am

    #943624

    Scheduling of SSIS packages would normally be done with SQL Server Agent and is not very difficult to do.

    If you try it you should quickly see how it's done.

    FYI, if you had googled the title of your post you would found the answer to your question.


    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]

  • February 13, 2009 at 8:26 am

    #943657

    The first link is how to run SSIS package as a Job, while the second covers known issues the most important the package executes in the context of the Agent so the Agent account must be admin. If your package is to other RDBMS the owner of the package must also be admin. You can create a proxy account for the Agent but the owner of the package must be admin.

    http://support.microsoft.com/kb/912911

    http://support.microsoft.com/kb/918760

    Kind regards,
    Gift Peddie

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

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