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

Article translations Article translations
Article ID: 921929 - View products that this article applies to.
Bug: #983 (SQL Hotfix)
Expand all | Collapse all

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

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"

Properties

Article ID: 921929 - Last Review: November 20, 2007 - Revision: 1.3
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
Keywords: 
kbexpertiseadvanced kbtshoot kbbug kbsql2005ssis KB921929

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com