I entered a set of database maintenance plans in SQL 2005 and wanted to export them to other servers. I've built four database servers on this Windows 2003 server, all named instances. One is SQL 2000, the others are all SQL 2005. SSIS is running on this Windows server using the server name, since it doesn't support multiple instances. The maintenance plans are all functioning properly.
I wanted to export the maintenance plans to other servers and the research I've done directs me to go into Integration Services, open up the MSDB database and select the packages there, and select export. The problem I had was that when I attempted to open up MSDB I would always get a connection failure.
After posting to MSDN Forums for some help, I solved the problem myself, by just slowing down a bit. I stopped Integration Services on the Windows Server, changed the c:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml file setting to the name of the server I thought contained the maintenance plans, and then restarted Integration Services. After that I was able to successfully connect to the SSIS and export the maintenance plans by opening up the MSDB database, drilling down to the maintenance plan I wanted to export, right-clicking, then selecting Export. I then entered the server name of the destination server (database server, not SSIS) and drilled down to the Maintenance Plans folder, and clicking OK.
The maint plans are now where I wanted them, without having to rebuild them for each server.
Allen