Cannot open DTS file in SQL Server 2008 Management Studio

Environment:

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

Requirement:

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

Steps:

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

Problem:


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)
------------------------------
OK
------------------------------

Solution:


  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.

Comments

Popular Posts