O'Reilly logo

Microsoft® SQL Server® 2008 Step by Step by Mike Hotek

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

Tasks

SSIS ships with 40 different tasks that can be added to a package. Tasks are broken into two broad categories: Control Flow tasks and Maintenance Plan tasks.

Note

Note

The Maintenance Plan that you built in Chapter 20, is an SSIS package.

The main tasks that you will use are shown in Figure 24-1.

Control Flow tasks

Figure 24-1. Control Flow tasks

The set of tasks that begin with "Transfer" are used to copy objects within an environment and can be used for code deployment or to synch objects to a standby server participating in log shipping or database mirroring.

The Analysis ...

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