One of my client was unable to modify the maintenance plan using SSMS. When we did various tests, we found that existing maintenance plans could execute and work. We tried creating a new maintenance plan and found it to be working.  So, our issue is confined to “unable to modify existing plans”. Here is the error message

Error: Microsoft SQL Server Management Studio is unable to load this document:

Could not load type ‘Microsoft.SQLServer.Dts.Runtime.Wrapper.IDTSPackageSigning100’ from assembly
‘Microsoft.SQLServer.DTSRuntimeWrap.Version=10.0.0.0.Culture=neutral.PublicKey Token=89845dcd8080cc91’.

The error was talking about version 10.0.0.0 and I think it’s the same for SQL 2008 and SQL 2008 R2.

 

SOLUTION/WORKAROUND

SSMS issue was resolved for my client by installing the right version of shared components. There were 2 instances on this machine; SQL Server 2008 RTM and SQL Server 2008 R2. We uninstalled shared components for the SQL Server RTM and installed shared components from SQL Server 2008 R2 media. After doing the above steps, we could edit the maintenance plans.

Here are a few related blog posts about SQL Server Maitainance Plans:

SQL SERVER – Maintenance Plan fails with 0x80131904 – A network-related or instance-specific error occurred while establishing a connection to SQL Server

SQL SERVER – Using “High Performance” Power Plan for SQL Server

SQL SERVER – Maintenance Plan Folder Missing Under Management in SQL Server Management Studio

Reference:Pinal Dave (http://blog.SQLAuthority.com) 

About the Author

Pinal Dave

Pinal Dave is a Microsoft Technology Evangelist (Database and BI). He has written over 1700 articles on the subject on his blog at http://blog.sqlauthority.com. He is a dynamic and proficient Principal Database Architect who specializes in SQL Server Performance Tuning and has 7+ years of hands-on experience. He holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET). He is also Regional Mentor for PASS Asia. Prior to joining Microsoft he was awarded Microsoft MVP award for three continuous years for his contribution in community.

Start the discussion at forums.toadworld.com