SSIS Maintenance Plan

  • Hye, I'm currently in charge of setting up maintenance plans on 100 plus servers.  What I would like to do is to build an SSIS project that would build the maintenance plans on these servers.  Is this possible?  I would like this to be done like this so the maintenance plans are not being run based on a centralized package, but on local jobs.  If anybody knows how to do this or has any ideas they would be greatly appreciated.

    -Kyle

  • If you are able to save your MP as a project then save it and deploy it across your other servers.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

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

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