• Use exception handling in DTS. SQL Server 2000 provides much better exception handling than SQL Server 7. I've run into this problem several times where a mainframe extract writes the same record more than once, because something changed while the mainframe extract was running.