Export (0) Print
Expand All

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.
© 2014 Microsoft