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

Extended support for SQL Server 2005 ended on April 12, 2016

If you are still running SQL Server 2005, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

This article has been archived. It is offered "as is" and will no longer be updated.
Bug: #983 (SQL Hotfix)
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.
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.
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
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
The installer does not install this hotfix correctly on x64-based systems. This installation issue occurs when the following conditions are true:
  • The system uses the Advanced Micro Devices (AMD) AMD64 processor architecture or the Intel Extended Memory 64 Technology (EM64T) processor architecture.

    Note This issue does not occur on systems that use the Intel Itanium processor architecture.
  • The system is running a 64-bit version of the Microsoft Windows Server operating system.
  • The system is running a 32-bit version of SQL Server 2000.
We have corrected this installation issue in later builds of SQL Server 2000, starting with version 8.00.2244. When a customer who is running SQL Server 2000 on an x64-based system requests this hotfix, we will provide a build that includes this hotfix and that can be installed correctly on an x64-based system. The build that we provide will be version 8.00.2244 or a later version.

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"

Article ID: 921929 - Last Review: 12/09/2015 06:14:34 - Revision: 1.3

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

  • kbnosurvey kbarchive kbexpertiseadvanced kbtshoot kbbug kbsql2005ssis KB921929