Data Transformation Services
Tasks That Function as Jobs
Data Transformation Services (DTS) includes a number of tasks that function as jobs, performing operations external to the packages containing the tasks.
| Task | Description |
|---|---|
| ActiveX Script Task | Uses scripting code to perform functions that are not available in the other tasks in DTS Designer. |
| Dynamic Properties Task | Retrieves values from sources outside a DTS package at package run time and assigns those values to selected package properties. |
| Execute Package Task | Runs other DTS packages as part of a workflow. |
| Execute Process Task | Runs an executable program or batch file as part of a package. |
| File Transfer Protocol Task | Downloads data files from a remote server or an Internet location as part of a package workflow. |
| Message Queue Task | Uses Message Queuing to send and receive messages between DTS packages. |
| Send Mail Task | Sends an e-mail message as a task. |