Cannot open DTS file in SQL Server 2008 Management Studio


Installed Microsoft SQL Server Management Studio 2008 on a Windows 7 Professional 64 bit machine.  


I would like to edit my legacy SQL Server 2000 DTS file.


By following the instruction on MSDN of installation of SQL Server 2000 DTS Designer Components, I still have the same error when I tried to open a DTS package


When I tried to open a DTS file in Management Studio, I received the below error:
Object Explorer
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)


  1. Download and Install "Microsoft SQL Server 2005 Backward Compatibility Components" x64 version (SQLServer2005_BC_x64.msi).
  2. Try again.  If it still not work.  Change the system variable below:
    1. changing the order in the PATH setting it got resolved.
      32 bit machine:
      C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;  should appear before the
      C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;
    2. 64 bit machine:
      C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\; should appear before
      C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;
    3. Restart SQL Server Management Studio to make the change effective.


Popular Posts