Creating SQL Maintenance Plans from SSIS Package

Posted on 2011-04-18
Last Modified: 2012-06-27
I created an SSIS Package in Visual Studio, and saved a copy of the package on my local SQL Server as an MSDB Maintenance Plan.  When I open up the SQL Management Studio, I have to connect using the 'Integration Services' Server Type to see the package in Maintenance Plans.  But, I don't know how to migrate the plan so I can see it in 'Management/Maintenance Plans' on the Server so I can schedule it.  How do I do this?  

FYI, I can create a job with the package and schedule it that way, but I need to do it as a MP.

Question by:DaneBigham
    LVL 29

    Expert Comment

    Lets establish if sql considers it an MP first.
    If you run this query against MSDB - do you see your package there?
    SELECT *  FROM [msdb].[dbo].[sysdbmaintplans]

    LVL 29

    Accepted Solution

    Sorry got ahead of myself there...

    You should be selecting against this table
    FROM [msdb].[dbo].[sysdtspackages90]

    not the one I posted before

    Author Comment

    the table is actually 'sysdtspackages' (there's also a 'sysdtslog90'), but there are no rows in the table.  I can see it when I look at the tree view in Integration Services.  I was able to create a job, and an MP that refers to the job.  

    From my research, it seems I'm unable to create an editable Maintenance Plan.  If that's the case, I can live with it.
    LVL 29

    Expert Comment

    You're right, sql2005 had the 90 suffix to denote the version number

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
    Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now