Import and Export SQL 2005 Maintenance plans

Login to SSIS on server with plans to export

Navigate to Stored Packages – MSDB – Maintenance Plans

Right click on the maintenance plan you want to export – choose Export Package

Choose package location (I usually use File System for easy transfer to another server)

Login to SSIS on server you want to import plans on to

Navigate to Stored Packages – MSDB

Right click on Maintenance Plans – choose Import Package

Navigate to where exported package lives

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.