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"

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:

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. (http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en)

• 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: 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.

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

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.