11.2. Administering and Editing a DTS Package
The good news is that even though the interface may not be superb, you can still edit, run, and schedule packages inside SQL Server 2005. You can do this through Management Studio. Assuming you upgrade an existing SQL Server 2000 instance to SQL Server 2005, your DTS packages will be imported into the new SQL Server 2005 instance as DTS packages as well. They would appear in Management Studio when connected to the Database Engine under Management 
Legacy 
Data Transformation Services (shown in Figure 11-1). Any package would remain intact, except for those stored in the Metadata Repository.
Figure 11-1. Data Transformation Services shown in Object Explorer
You can open any package by right-clicking the package and selecting Open. However, in order to perform this task, you must have Microsoft SQL Server 2000 DTS Designer Components installed, which is part of the feature pack. To download this component, search for the SQL Server 2005 Feature Pack with your favorite search engine. The feature pack includes many additional tools that didn't make the installation DVD for SQL Server (such as the designer components, the DTS runtime, and ...
Get Expert SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
