MCSE Training Kit (Exam 70-228): Microsoft® SQL Server™ 2000 System Administration

Author Microsoft Corporation Pages 720 Disk 1 Companion CD(s) Level All Levels Published 03/28/2001 ISBN 9780735612471 ISBN-10 0-7356-1247-1 Price(USD) $59.99 To see this book's discounted price, select a reseller below.	More Information About the Book Table of Contents Sample Chapter Index Related Series Related Books About the Author Support: Book & CD Rate this book

Chapter 7: Populating a Database

• About This Chapter
• Before You Begin
• Lesson 1: Transferring and Transforming Data
• Importing Data
• DTS Data Transformations
• Introducing the Data Transfer Tools
• Lesson Summary
• Lesson 2: Introducing Microsoft Data Transformation Services (DTS)
• Understanding a DTS Package
• DTS Package Storage
• Introducing DTS Tools
• Lesson Summary
• Lesson 3: Transferring and Transforming Data with DTS Graphical Tools
• Using the DTS Import/Export Wizard
• Practice: Transferring Tables and Data from the Northwind Database Using the DTS Import/Export Wizard
• Using DTS Designer
• Practice: Creating a Data Transfer and Transform Package Using DTS Designer
• Extending DTS Package Functionality
• Lesson Summary
• Lesson 4: Working with DTS Packages
• Understanding DTS Package Storage Options
• Using DTS Package Execution Utilities
• Using DTS Package Logs and Exception Files
• Performing Disconnected Edits
• Lesson Summary
• Lesson 5: Using the Bulk Copy Program (Bcp) and the BULK INSERT Transact-SQL Statement
• Copying Data in Bulk Using Text Files
• Using Bcp
• Using the BULK INSERT Transact-SQL Statement
• Optimizing Bulk Copy Operations
• Lesson Summary
• Review

Chapter 7   Populating a Database

About This Chapter

Before You Begin

• A computer that meets or exceeds the minimum hardware requirements listed in Table 2.1 in the Lesson 1 section of Chapter 2.
• Microsoft Windows 2000 Server running on your computer on an NTFS partition.
• A computer with a NetBIOS name of SelfPacedCPU, configured as a domain controller in the SelfPacedSQL.MSFT domain.
• Installed a default instance and at least one named instance of SQL Server 2000 (see Chapter 2).

Top of Page

Last Updated: Saturday, July 7, 2001