O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

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

Using the DTS Designer

The DTS Designer is a graphical workspace for building sophisticated import, export, or transformation operations. Whereas the DTS Wizard is designed to handle most of your simple import or export needs, the DTS Designer picks up where the wizard leaves off by allowing you to define all your own tasks and set precedence constraints on the steps between these tasks.

You arrange source and destination data sources, along with other execution objects, in a fashion similar to a typical flowchart. Arrows connect these objects and form the tasks and steps of the package. These arrows provide the package with directional flow or conditional logic.

Creating a DTS Package and Adding Simple Workflow

To create a DTS package from the ...

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