FIX: Error message when you try to open SQL Server 2000 Data Transformation Services (DTS) packages in SQL Server Management Studio: "SQL Server 2000 DTS Designer components are required to edit DTS packages" (905417)


The information in this article applies to:

  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Personal Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Workgroup

SYMPTOMS

In Microsoft SQL Server Management Studio, you receive the following error message when you try to open Microsoft SQL Server 2000 Data Transformation Services (DTS) packages:
SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature.

RESOLUTION

To resolve this problem, download and then install the November 2005 Feature Pack for SQL Server 2005.

Download information

The following file is available for download from the Microsoft Download Center:

DownloadDownload the November 2005 Feature Pack for Microsoft SQL Server 2005 package now.
  • Microsoft SQL Server 2000 DTS Designer Components
  • Microsoft SQL Server 2005 Backward Compatibility Components
Release Date: November 16, 2005

For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to obtain Microsoft support files from online services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

STATUS

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

MORE INFORMATION

SQL Server 2005 developers and administrators can use the SQL Server 2000 DTS package designer to edit and to maintain existing SQL Server 2000 DTS packages. Developers and administrators can do this until they can use the SQL Server 2005 Integration Services package format to upgrade or re-create the DTS packages.

After you apply this hotfix, SQL Server 2005 users can continue to edit and maintain existing DTS packages by using the following tools without having to reinstall the SQL Server 2000 tools:
  • Object Explorer in SQL Server 2005 Management Studio
  • The Execute DTS 2000 Package Task Editor in Business Intelligence Development Studio
The DTS package designer that is included in this hotfix was previously available in the Data Transformation Services node in SQL Server 2000 Enterprise Manager.
Modification Type:MinorLast Reviewed:6/1/2006
Keywords:kbDownload kbbug kbfix kbHotfixServer kbQFE KB905417 kbAudITPRO kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.