Microsoft KB Archive/905417

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

Article ID: 905417

Article Last Modified on 11/3/2007

-

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 Edition

-





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, &quot;SQL Server 2000 DTS Designer Components&quot; 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:

Download 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 &quot;Applies to&quot; 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.

Keywords: atdownload kbdownload kbbug kbfix kbhotfixserver kbqfe KB905417

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.