We have 2 x SQL 2000 servers in our BI environment. In our OLTP production environment we have a couple of SQL 2005 servers running apps that don't support 2008 yet. And we also have a couple of SQL 2008 servers running an app that does support 2008.
The main reason our BI environment still runs on SQL 2000 is because we have a whole lot of DTS code and we haven't yet gotten around to migrating it to SSIS.
I would be interested to know how many other people are finding DTS a bit of an obstacle to their upgrade progress from SQL 2000.
Best Regards
Joe Trainor
Head of BI
Virgin Active South Africa