Editing an old SQL Server 2000 DTS in SQL Server 2005

Question

Hi,

I've imported a SQL Server 2000 dts package in a SQL Server 2005 environment, but now I need to open and edit the dts package. The DTSObjectExplorerUI is required.

Does anyone know where I can download it? Thanks

Answer 1

It is part of the SQL 2005 feeature pack

http://msdn.microsoft.com/en-us/library/cc768544(v=sql.100).aspx

Microsoft SQL Server 2000 DTS Designer Components

The Microsoft SQL Server 2000 Data Transformation Services (DTS) package
designer is a design tool used by developers and administrators of SQL Server
2005 servers to edit and maintain existing DTS packages until they can be
upgraded or recreated in the SQL Server 2005 Integration Services package
format. After installing this download, SQL Server 2005 users can continue to
edit and maintain existing DTS packages from the Object Explorer in SQL Server
2005 Management Studio and from the Execute DTS 2000 Package Task Editor in
Business Intelligence Development Studio, without needing to reinstall the SQL
Server 2000 tools. The DTS package designer in this download was formerly
accessed from the Data Transformation Services node in SQL Server 2000
Enterprise Manager.

Note: SQL Server 2000 Data Transformation
Services (DTS) is a 32-bit only feature. DTS is supported in WOW on the x64
platform, but is not supported on the Itanium platform.

Audience(s):
Customer, Developer



X86
Package (SQLServer2005_DTS.msi)

---

Chuck

Answer 2

Ok, thanks. I've already found the download. Many thanks