Supported Task Types

There are differences in how the custom tasks available through Data Transformation Services (DTS) participate in transactions. For example:

• Some tasks perform operations that cannot take part in a transaction. For example, the File Transfer Protocol (FTP) task writes files directly to disk. No rollback is possible. Other such tasks are:
  • The Dynamic Properties task.
    
    
  • The Send Mail task.
    
    
  • The Copy SQL Server Objects task.
• Some tasks allow the user to create their own scripts or programs and run them from DTS. Although these tasks can create and independently manage their own local or distributed transactions, they have no access to the DTS package transaction. These tasks are:
  • The Microsoft® ActiveX® Script task.
    
    
  • The Execute Process task.
• Some supported tasks can join the package transaction if the right connections are supported. These tasks are:
  • The Bulk Insert task.
    
    
  • The Data Driven Query task.
    
    
  • The Transform Data task.
    
    
  • The Execute Package task.
    
    
  • The Execute SQL task.
    
    
  • The Message Queue task.

All of the above three groups of tasks may commit or roll back the current transaction.

See Also

Bulk Insert Task

Data Driven Query Task

Execute SQL Task

Inherited Transactions

Message Queue Task

Transform Data Task