Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 905417 - Last Review: November 3, 2007 - Revision: 2.3
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:
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.
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:
Collapse this imageExpand this image
- 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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=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.
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.
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
| atdownload kbdownload kbbug kbfix kbhotfixserver kbqfe KB905417 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate