Wednesday, December 16, 2009

Opening SQL 2000 DTS Packages from SSMS

I got my DTS tools working on SQL2008 SSMS. Here is how I did it.

1. I Installed the following from the appropriate links:
  • Microsoft SQL Server 2005 Backward Compatibility Components
  • Microsoft SQL Server 2000 DTS Designer Components
2. Then I had to modify my path as described in this article:
  • “Update the PATH environment variable in such a way that the path “C:\Program Files\Microsoft SQL Server\80\Tools\Binn\” appears before the “C:\Program Files\Microsoft SQL Server\100\...” paths.”

No comments: