ALS Microsoft® SQL Server™ 2000 System Administration

Author Microsoft Corporation Pages 944 Disk N/A Level Beg/Int Published 07/03/2001 ISBN 9780735614260	More Information About the Book Table of Contents Sample Chapter Index Related Series Related Books About the Author Support: Book & CD

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