Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Tasks That Function as Jobs

SQL Server 2000

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.

© 2015 Microsoft