Exporting SQL Maintenance Plans

I have taken a look at the new maintenance plan designer and have come up with a maintenance plan I would like to be able to deploy on an enterprise level. Anyone know of a way I can export the plan to another SQL 2005 server - without directly pulling from the msdb system tables? I like the fact that you can script the output of most of the wizards, but the maintenance plan wizard does not appear to be one of them.

Thanks,

MattI also really need to know how to do this. We want standardized maintenance plans at all of our clients and creating these by hand is a pain in the a$$. How can you do this? I see that you can create SSIS packages to do the same thing, but can you deploy those on people who run SQL express?|||

You can import and export maintenance plans. Connect to
Integration Services on the server where the maintenance
plans are located. Go to Stored Packages -> MSDB ->
Maintenance Plans. From there you can right click on
Maintenance Plans and select Import. Or if you right click
on one of your maintenance plans, you can select import or
export.

Thanks

|||

Ahh I see! I was always connecting to just SQL. Forgot about all the other services in the drop down list.

I also found another way:

select name,cast(cast(packagedata as binary) as varchar(max)) from sysdtspackages90

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=389519&SiteID=1&mode=1

But your way is much easier.

|||

Very helpfull, thank you.

What do you suggest if you have a maintenace plan in a named instance(not default), which you vould like to copy ?