DTS Overview
 DTS Basics
 DTS Tools
    DTS Import/Export Wizard
       Creating a DTS Package with the DTS Import/Export Wizard
    DTS Designer
       Creating a DTS Package with DTS Designer
          DTS Designer Example: A Completed DTS Package
          DTS Designer Example: Copying Northwind Data
       DTS Package Templates
    DTS and SQL Server Enterprise Manager
    DTS Package Execution Utilities
    DTS Query Designer
 DTS Package Elements
    DTS Tasks
       Tasks That Transform Data
          Transform Data Task
          Data Driven Query Task
             Data Flow in a Data Driven Query Task
             Building a Data Driven Query
             Data Driven Query Example: Changing Customer Accounts
             Data Driven Query Example: File Maintenance
          Multiphase Data Pump Functionality
       Tasks that Copy and Manage Data
          Bulk Insert Task
          Execute SQL Task
          Copy SQL Server Objects Task
          Transfer Database Objects Tasks
       Tasks That Function as Jobs
          ActiveX Script Task
          Dynamic Properties Task
          Execute Package Task
          Execute Process Task
          File Transfer Protocol Task
          Message Queue Task
             Installing and Configuring Message Queuing
             Message Types
             Sending Messages with the Message Queue Task
             Receiving Messages with the Message Queue Task
                Receiving String Messages
                Receiving Data File Messages
                Receiving Global Variables Messages
             Message Queue Task Examples
                Using String Messages to Trigger Tasks
                Using Global Variable Messages to Queue Database Updates
                Using Data File Messages to Collect Data
          Send Mail Task
    DTS Transformations
       Mapping Column Transformations
       Transformation Types
          Copy Column Transformation
          ActiveX Script Transformation
          Date Time String Transformation
          Lowercase String Transformation
          Uppercase String Transformation
          Middle of String Transformation
          Trim String Transformation
          Read File Transformation
          Write File Transformation
    DTS Connections
       Data Link Connection
    DTS Package Workflow
       Using ActiveX Scripts in a DTS Workflow
 Managing a DTS Package
    Creating a DTS Package
    Editing a DTS Package
    Deleting a DTS Package
    Executing a DTS Package
       Scheduling a DTS Package for Execution
    Saving a DTS Package
       Saving a DTS Package to SQL Server
       Saving a DTS Package to Meta Data Services
       Saving a DTS Package to a Structured Storage File
       Saving a DTS Package to a Visual Basic File
    Using DTS Package Logs
    Managing DTS Package Properties
       Viewing and Modifying DTS Package Properties
       Editing DTS Package Properties with Disconnected Edit
    Handling Package Security in DTS
 Adding Functionality to a DTS Package
    Using ActiveX Scripts in DTS
       Using Return Codes in DTS
       Debugging ActiveX Scripts
    Incorporating Transactions in a DTS Package
       Configuring Properties for DTS Transactions
       DTS Transaction Fundamentals
          Inherited Transactions
          Supported Connection Types
          Supported Task Types
       Designing DTS Transactions
          Sequential Execution
          Parallel Execution
          Checkpointing Package Transactions
          Branching on Transaction Failure
    Lookup Queries
       Configuring a Simple Lookup Query
       Managing Zero or Multiple Result Rows in Lookup Queries
       Using Lookup Queries to Modify Data
       Using Multiple Lookup Queries
    Using Global Variables with DTS Packages
    Using Parameterized Queries in DTS
    Querying a DTS Package from External Sources
       Querying a Package with OPENROWSET
       Issuing Distributed Queries Against Package Data
 Sharing Meta Data
    DTS Information Model
    Recording Data Lineage in DTS
    Importing and Saving Meta Data in DTS
    Viewing Meta Data in DTS
 Usage Considerations in DTS
    Enhancing Performance of DTS Packages
    Data Conversion and Transformation Considerations
    DTS Driver Support for Heterogeneous Data Types
    Enhancing Data Driven Queries in DTS
    Enhancing Lookup Queries in DTS