I recently uninstalled the SQL Server 2000 Enterprise Manager Client on my laptop and started using the SQL Server 2005 Management Studio Client to manage my existing SQL Server 2000 Databases. I'm hoping this helps me aquaint myself with SQL Server 2005 faster. After doing so, I noticed that I couldn't open existing SQL 2000 DTS Packages. The solution to this issue was to download/install the “Microsoft SQL Server 2000 DTS Designer Components” from the Feature Pack for Microsoft SQL Server 2005 - November 2005. I also found that Microsoft recently released some additional SQL Server 2005 Downloads. See Below.
Enjoy!!!
SQLDiva
Feature Pack for Microsoft SQL Server 2005 - November 2005 ===>
Includes:
Microsoft ADOMD.NET
Microsoft Core XML Services (MSXML) 6.0
Microsoft OLEDB Provider for DB2
Microsoft Operations Manager 2005 Management Pack for Microsoft SQL Server 2005
Microsoft SQL Server 2000 PivotTable Services
Microsoft SQL Server 2000 DTS Designer Components
Microsoft SQL Server Native Client
Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider
Microsoft SQL Server 2005 Backward Compatibility Components
Microsoft SQL Server 2005 Command Line Query Utility
Microsoft SQL Server 2005 Datamining Viewer Controls
Microsoft SQL Server 2005 JDBC Driver
Microsoft SQL Server 2005 Management Objects Collection
Microsoft SQL Server 2005 Mobile Edition
Microsoft SQL Server 2005 Notification Services Client Components
Microsoft SQL Server 2005 Upgrade Advisor
Microsoft .NET Data Provider for mySAP Business Suite, Preview Version
Reporting Add-In for Microsoft Visual Web Developer 2005 Express
SQL Server 2005 Books Online (April 2006) ===>
SQL Server 2005 Samples and Sample Databases (April 2006) ===>