BUG: When you click "Build Query" in the "Execute SQL Task Properties" dialog box of the SQL Server 2000 DTS package designer, SQL Server 2005 Management Studio unexpectedly closes (921929)

The information in this article applies to:

Microsoft SQL Server 2005 Standard Edition
Microsoft SQL Server 2005 Standard X64 Edition
Microsoft SQL Server 2005 Developer Edition
Microsoft SQL Server 2005 Enterprise Edition
Microsoft SQL Server 2005 Enterprise X64 Edition
Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems

Bug: #983 (SQL Hotfix)

SYMPTOMS

Consider the following scenario in Microsoft SQL Server 2005 Management Studio (Sqlwb.exe):

You are editing a Microsoft SQL Server 2000 Data Transformation Services (DTS) package in the SQL Server 2000 DTS package designer.
The DTS package contains an Execute SQL task.
You click Build Query in the Execute SQL Task Properties dialog box to open DTS Query Designer.

In this scenario, SQL Server Management Studio may unexpectedly close. Additionally, you may receive the following error message in the Visual Studio Just-In-Time Debugger dialog box:

An unhandled exception ('System.AccessViolationException') occurred in SqlWb.exe

Note This problem does not occur on computers that have Microsoft SQL Server 2000 installed.

CAUSE

This problem occurs when one or more of the following files are missing from the C:\Program Files\Common Files\Microsoft Shared\MSDesigners98 folder:

Msdt70.dll
Mdw9x70.dll
Mdt3g.dll

By default, the missing files are not included with Microsoft SQL Server 2005 or with the separate download of the SQL Server 2000 DTS Designer Components feature pack for SQL Server 2005.

These files are installed when you install the SQL Server 2000 client tools. Therefore, you will experience this problem if SQL Server 2000 and the SQL Server 2000 client tools were not previously installed on the computer.

WORKAROUND

To work around this problem, install the SQL Server 2000 client tools. Additionally, install the latest service pack for the SQL Server 2000 client tools.

The SQL Server 2000 client tools are included on the SQL Server 2000 installation CD. However, you may be able to copy the required files from the following folder on a computer that is running SQL Server 2000:

C:\Program Files\Common Files\Microsoft Shared\MSDesigners98

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.

This problem is fixed in the SQL Server 2000, build 80.2204.0, version of the following file:

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Dtsui.dll

MORE INFORMATION

For more information about DTS, see the following topics in SQL Server 2005 Books Online:

"Migrating Data Transformation Services packages"
"SQL Server 2005 Integration Services backward compatibility"
"How to ensure support for Data Transformation Services packages"

Modification Type:	Major	Last Reviewed:	9/6/2006
Keywords:	kbExpertiseAdvanced kbtshoot kbBug kbsql2005ssis KB921929 kbAudDeveloper kbAudITPRO