Lesson 1: Using DTS in a Data Warehouse

• Defining Data Transformation Services
• Identifying DTS Applications
• Defining the Data Warehouse System
• Applying DTS to the Data Warehouse

Lesson 2: Defining Data Warehouse Structures

• Defining the Polaris Data Warehouse
• Identifying Source and Destination Structures
• Defining Dimension Tables
• Defining Fact Tables
• Implementing the Star Schema

Lesson 3: Populating Data Warehouse Structures

• Reviewing the Star Schema Data Load
• Defining the Dimension Data Load
• Defining the Fact Table Data Load
• Implementing Staging Tables
• Applying Data Transformation Services
• Using DTS to Populate the Sales Star

Lesson 4: Using the DTS Import/Export Wizard

• Defining the Import/Export Wizard
• Copying Objects Between Heterogeneous Databases
• Copying Tables from Microsoft Access 2000 to SQL Server
• Creating a Prototype Package
• Loading the Employee_dim Dimension
• Loading the Product_dim Dimension

Lesson 5: Understanding DTS Package Elements

• Learning Package Components
• Using DTS Package Designer
• Defining Package Connections
• Defining Package Tasks
• Defining Package Steps
• Storing and Executing Packages
• Adding a Parallel Data Load to Product_dim

Lesson 6: Copying and Managing Data

• Identifying DTS Tasks That Copy and Manage Data
• Using the Bulk Insert Task
• Loading Staging Tables
• Using the Execute SQL Task
• Using the Copy SQL Server Objects Task

Lesson 7: Performing Data Transformations

• Performing Transformations in DTS
• Defining the Transform Data Task
• Setting Up the Source and Destination
• Creating Transformations
• Configuring Error Handling
• Optimizing for SQL Server Destinations

Lesson 8: Extending Transformations

• Building Microsoft ActiveX Script Transformations
• Creating Advanced Transformations
• Using Lookup Queries
• Implementing SQL Solutions
• Using the Multiphase Data Pump

Lesson 9: Implementing Data Driven Query Solutions

• Using the Data Driven Query Task
• Building a Data Driven Query Task Solution
• Maintaining Slowly Changing Dimensions
• Refreshing the New_product_dim Table
• Learning Best Practices for the DDQ

Lesson 10: Storing DTS Packages and Metadata

• Understanding Package Versions
• Storing DTS Packages
• Securing DTS Packages
• Storing Metadata
• Tracking Data Lineage

Lesson 11: Executing Packages

• Defining Package Executions
• Executing Packages Interactively
• Using Package Execution Utilities
• Creating Package Execution Logs
• Executing Moduleal Packages
• Scheduling Packages

Lesson 12: Managing Package Properties

• Reviewing DTS Package Elements
• Understanding Disconnected Edit
• Using the Dynamic Properties Task
• Managing Connection Properties

Lesson 13: Building Advanced Workflows

• Implementing Asynchronous Workflows
• Implementing Package Transactions
• Creating a Package Loop

Lesson 14: Applying Best Practices

• Defining the Data Load Scenario
• Developing Packages
• Choosing Tasks
• Designing Transformations
• Defining Workflows
• Storing and Executing Packages
• Managing Packages

Lesson 15: Case Study - Populating the Shipments Star

• Defining the Shipments Star
• Populating the Shipments Star
• Migrating the Shipments Star