Designing DTS Transactions

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.