Today, in order to experience the new features of SQL Server 2005, malicious to kill the native SQL Server 2000, installed a SQL Server 2005, experienced a lot of new features, then suddenly remembered that there are some DTS improvement work has not been completed, Then, using SQL Server Management Studio to link to the SQL Server 2000 Server, open the DTS package, and when you are trying to edit it, there is an error: Editing the DTS package requires SQL Server Master DTS Designer components. To use this feature, install a special Web download file, SQL Server, DTS Designer component. This means that SQL Server 2005 SQL Server Management Studio By default cannot edit DTS (SQL Server 2000 DTS). To address this problem, Microsoft has added a patch for users to download. After this patch is installed, you can edit the DTS package like SQL Server 20,001.
SQL are DTS tools now available as part of the-
Download details:feature Pack for SQL Server Nov 2005
(Http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang =en)
The direct link to the msi-
http://www.microsoft.com/downloads/info.aspx?na=46&p=16&srcdisplaylang=en&srccategoryid=& srcfamilyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&u=http://download.microsoft.com/download/4/4/d/ 44dbde61-b385-4fc2-a67d-48053b8f9fad/sqlserver2005_dts.msi&oref=http://forums.microsoft.com/msdn/ Showpost.aspx? Postid=126513&siteid=1
