Chapter 8 -- Advanced DTS

Chapter 8

About This Chapter

In this chapter, you will learn how to take advantage of the rich functionality provided by DTS. You can create DTS packages that use complex workflows and data transformations using DTS Designer, and you can program DTS using COM automation. In this chapter, you will create a package that loads the Northwind_Mart OLAP database with data from the Northwind OLTP database.

Before You Begin

To complete the lessons in this chapter you must

• Have installed SQL Server 7.0.
• Be able to log in to SQL Server as an Administrator.



• Have installed the Exercise files from the Supplemental Course Materials CD-ROM to your hard disk drive. See the "Getting Started" section in "About This Book" for installation instructions.
• Have completed the exercises in Chapter 5, "Defining the Technical Architecture for a Solution," to create the Northwind_Mart database and the tables in the Northwind_Mart database. If you have not created the Northwind_Mart database, you can execute the script located in C:\SQLDW\Exercise\Ch08\Northwind_Mart.sql to create the database.