Chapter 4. DTS Tasks

DTS Tasks

Tasks define the work units that are performed within a DTS package. They are the means by which you specify what you want to happen when the package executes.

Microsoft SQL Server provides several predefined tasks right out of the box. These tasks enable you to copy and manage data, copy and manage SQL Server databases as well as database objects, execute SQL statements and scripts, send mail, and more.

Table 4.1 lists the built-in tasks that come with SQL Server 2000. Note how the tasks are grouped, starting with the data-movement tasks, whose primary functions are to move and transform data. The Transform Data Task is a high-speed ...

Get SQL Server DTS now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.