May 22, 2006 at 3:33 pm
I have a developer who would like to use 2005's EM to edit/modify SQL 2000 DTS packages. But he receives an error. We found the following in the documentation concerning the error:
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
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.
May 23, 2006 at 11:31 pm
I never installed a hotfix, but did install the web download "SQL Server DTS Designer Components" and it worked perfectly.
This may have been before the hotfix you mentioned. Did you find the web download separately from the hotfix?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply