We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now


Creating SQL Maintenance Plans from SSIS Package

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.

Watch Question


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]

Unlock this solution and get a sample of our free trial.
(No credit card required)


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.

You're right, sql2005 had the 90 suffix to denote the version number
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.