Incorporating Transactions in a DTS Package

DTS Designer provides transaction capabilities, allowing you to assign tasks in a workflow to a transaction, and commit and roll back individual steps based on the success or failure of the transactional unit.

There are several considerations you need to know before creating transactional units in DTS Designer:

• The data provider being used must support transactions; specifically, the OLE DB ITransactionJoin interface must be supported. Refer to your provider documentation for this information.
• Only one concurrent transaction at a time is supported in the DTS Designer. If you want to use multiple transactional units, you need to serialize them (that is, one transactional unit must complete before the next one begins).