Article ID: 921929
Article Last Modified on 11/20/2007
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:
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"
Keywords: kbtshoot kbbug kbexpertiseadvanced kbsql2005ssis KB921929