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
OK
------------------------------
Solution:
- Download and Install "Microsoft SQL Server 2005 Backward Compatibility Components" x64 version (SQLServer2005_BC_x64.msi).
- Try again. If it still not work. Change the system variable below:
- 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\; - 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\; - Restart SQL Server Management Studio to make the change effective.
Comments