Support for SQL Server 2000 DTS package design

Support for SQL Server 2000 DTS package design

You cannot open or edit the DTS package directly in Business Intelligence Development studio. In addition, SQL Server 2005 does not install the DTS package designer used to edit the DTS package. However, you can download and install the updated version of the DTS package designer and use the updated version to modify the DTS package. To download the updated DTS package designer, visit the Microsoft Feature Pack for Microsoft SQL Server 2005 (Microsoft SQL Server 2005 Feature Pack) and download the Microsoft SQL Server 2000 DTS designer component. After installation and download, you can go to management studio or in business intelligence development studio"Execute DTS 2000 Package task Editor"To view and edit the data transmission package.

Manage some DTS applications that affect the DTs design environmentProgramFor details about the attributes, see set attributes of DTs applications.

Microsoft SQL Server 2000 DTS designer component

Http://www.microsoft.com/downloads/zh-cn/details.aspx? Familyid = 50b97994-8453-4998-8226-fa42ec403d17