Mar 14, 2017 8:30:26 PM by Pinal Dave
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
The error was talking about version 10.0.0.0 and I think it’s the same for SQL 2008 and SQL 2008 R2.
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:
Reference: Pinal Dave (http://blog.SQLAuthority.com)
Tags: SQL Server
Written by 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.