Creating SQL Maintenance Plans from SSIS Package
Posted on 2011-04-18
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.