Chapter 6 -- SQL Server Data Services

Chapter 6

About This Chapter

In this chapter, you begin to address the issue of loading data into your data warehouse from various sources. SQL Server provides extensive support for access to native SQL Server databases and other data. This support is built upon the OLE DB specification. Data Transformation Services (DTS) in SQL Server 7 provide a powerful, flexible tool for performing many kinds of data transfer and loading and are ideally suited to loading your data warehouse.

This chapter introduces data-loading concepts such as data scrubbing and data transformation, OLE DB architecture, and DTS.

Before You Begin

To complete the lessons in this chapter you must

• Have installed SQL Server 7.0.
• Be able to log on 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.