With the SQL Server 2000 DTS has very good capability of treating the huge processes as transactions, let's assume these parameters: DTS Package with "Use Transactions" and "Commit on successful package completion" boxes checked. No transaction related Read More...