• 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