does anyone have a short example of code (let's say in C#) which can generate Maintenance Plan (could be SSIS package).
We have hundreds SQL Servers in our scope, and it would be much easier for us to automate deploy and backup of them. We do not want to use specialized tools like Quest LiteSpeed etc. But we would prefere to create C# command line program which will allow us to easily create Maintenance Plan (or SSIS package) which will be automatically deployed to target SQL 2005, 2008, 2008R2 Server and will backup and do basic maintenance tasks upon all online databases which are there. We have found some examples on : http://technet.microsoft.com/en-us/library/ms345167.aspx
, but more related to SSIS packages than SQL Maintance Plans.
Any help will be widely appreciated.