Article ID: 922546 - Last Review: November 20, 2007 - Revision: 1.2

You receive a "No description found" error message when you create an SSIS package or a SQL Server maintenance plan in SQL Server 2005

View products that this article applies to.

System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

Expand all | Collapse all

SYMPTOMS

When you try to create a Microsoft SQL Server 2005 Integration Services (SSIS) package or a SQL Server maintenance plan, you receive the following error message:

No description found

This issue occurs when you install the original release version of Microsoft Office Visio 2003 after you install SQL Server 2005.

Note You may also experience this problem when you run the SQL Server Import and Export Wizard.

Back to the top

CAUSE

This problem occurs because the Microsoft Office Visio 2003 Setup program incorrectly sets the registry entries for Microsoft Core XML Services (MSXML). In this case, the wrong version of the Msxml.dll file is being used when you create SSIS packages or maintenance plans.

Back to the top

RESOLUTION

To resolve this problem, install Microsoft Office Visio 2003 Service Pack 1. For more information about how to obtain Visio 2003 Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:

873460 (http://support.microsoft.com/kb/873460/ ) How to obtain the latest service pack for Visio 2003

Back to the top

WORKAROUND

To work around this problem, uninstall Visio 2003, and then reregister MSXML 3.0 or MSXML 4.0 for SQL Server 2005. To reregister MSXML, click Start, click Run, type the following command, and then click OK:

Regsvr32 "C:\WINDOWS\system32\msxml3.dll"

Note This command assumes that you want to reregister MSXML 3.0 and that the .dll file is located in the C:\WINDOWS\system32\ folder.

Back to the top