O'Reilly logo

SQL Server DTS by Steve Hughes,, Steve Miller,, Marcelino Santos,, Brian Sullivan, Jim Samuelson,

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required