Creating SQL Maintenance Plans from SSIS Package

Posted on 2011-04-18
Medium Priority
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
  • 3
LVL 29

Expert Comment

ID: 35421476
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

QPR earned 2000 total points
ID: 35421503
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

ID: 35421703
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

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

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

850 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