I have a number of DTS packages set up that publish from our local SQL Server 2000 database to a SQL Server 2005 database on our live web server (these were originally set up in Enterprise Manager). We've had to migrate to a new live host which is using SQL Server 2008, but we still need to publish from the MSSQL 2000 database. Can I still publish using these packages?
Additionally this new host does not have MSSQL 2008 Integration Services installed, and are not able to install this, so I cannot use the package update wizard in SQL Server Management Studio.
How is it possible to execute these DTS packages seeing as it seems Enterprise Manager won't allow connections to SQL Server 2008 databases?