"No description found" Error when modifying Maintenance Plans

When you are trying to modify a maintenance plan; sometimes you might get “No Description Found” error and you cannot do any work in SSIS when that happens.

Everything was working properly for me until I had to install Microsoft Visio 2003 and I couldn’t update my maintenance plans any more.

In the reference link it explains because of MSXML DLL issue in Visio 2003 RTM edition it causes the issue with SSIS packages. Installing the newest Service Pack for Visio resolves the issue after reboot.

So this is not an issue with SQL Server Egine or SSIS Engine but just the Sql Server Management Studio (SSMS).

I also read an post on SQL Server Central where someone stated they got it to work just after running following commands also:

Regsvr32 “C:\WINDOWS\system32\msxml.dll”
Regsvr32 “C:\WINDOWS\system32\msxml3.dll”

You still have to reboot computer; I wanted to get the updates for Visio anyhow, so I didn’t get chance to try that.

Ref Link: http://support.microsoft.com/kb/922546

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.