Opening SQL 2000 DTS package in Microsoft SQL Server Management Studio

• ronhall7610

  SSC Rookie

  Points: 30

  More actions

  November 4, 2005 at 7:39 am

  #166132

  When I connect to a SQL 2000 server and I try to open up a SQL 2000 DTS package, I get this error.

  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. (Microsoft.SqlServer.DtsObjectExplorerUI)

  I have searched for the "SQL Server 2000 DTS Designer Components" download but I cannot seem to find it anywhere. 

  Any help would be greatly appreciated.

• November 7, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Anthony Kautz

  Grasshopper

  Points: 11

  More actions

  November 8, 2005 at 1:52 pm

  #602881

  I am not sure if it will work, but you can go to the following link:

  http://www.microsoft.com/downloads/details.aspx?FamilyID=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en

  then download and install the file (SQLServer2005_DTS.msi).