Friday, November 4, 2011

Opening SQL Server 2000 DTS Package in SQL Server 2008

Error:

TITLE: 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)

------------------------------
BUTTONS:

OK
------------------------------

Fix: Install SQLServer2005_BC & SQLServer2005_DTS softwares from http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=11988

If you are still not able to get it working. Please follow the below steps:

The issue was with PATH environment variable setting.

After changing the order in the path setting it got resolved.



C:\Program Files\Microsoft SQL Server\80\Tools\Binn\; should appear before the

C:\Program Files\Microsoft SQL Server\100\Tools\Binn\;

Incase of 64 bit machine:

C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\;

Be sure to restart the SSMS after changing the PATH env variable