Yes, you can edit and maintain DTS in SSMS 2008 running on SQL Server 2008.  We have a great deal of DTS – so it is a must (may not like it :-)

I received my new laptop.  Didn’t want to install SSMS 2000 to support DTS.  I found a helpful link from Mike Wood.  From a fresh build, there were a few steps missing.  Here are the steps that worked for me.

1. Install Microsoft SQL Server 2005 Backward Compatibility Components

2. Install the 2005 DTS Designer: x86 Package.

This installs the DTS Designer into the 2005 directories so you’ll then need to copy the files over to the 2008 directories. Make sure Management Studio is closed when you run the following commands (we create a batch file to do this typically). Make sure you also replace the path with your own drive and path: SQL08DTS.txt

After that just open up SQL Management Studio 2008 and edit/run DTS packages... or until they get migrated.