TABLE 1: Built-in DTS Tasks

ExecuteSQLTask Executes one or more SQL statements. DataPumpTask Copies and transforms data from a source to a destination data store. ActiveXScriptTask Executes an ActiveX script. These tasks can perform any operation that the language supports including interaction with ADO and invocation of any other object supporting OLE Automation. ExecuteProcessTask Executes an external program. BulkInsertTask Performs a SQL Server/T-SQL Bulk Insert operation. SendMailTask Sends an email or page using SQL Mail. DataDrivenQueryTask Performs advanced data transformations between data stores. TransferSQLServerObjectsTask Transfers complete objects from one SQL Server 7.0 database to another.