Designing DTS Transactions
SQL Server 2000
It is strongly recommended that you follow a few general design principles when you design Data Transformation Services (DTS) transactions to greatly reduce the chance of anomalous results:
- If possible, organize tasks sequentially.
- When steps execute in parallel, use DTS package failure to roll back the transaction.
- Use checkpoint tasks to commit intermediate results within a package.
- Use the Execute Package task and package failure to branch on transaction failure.