Chapter 20. Importing and Exporting SQL Server Data Using BCP and DTS

by Paul Bertucci

IN THIS CHAPTER

  • Bulk-Copy Program (BCP)

  • The Bulk-Copy Program

  • Logged and Non-Logged Operations

  • The BULK INSERT Statement (Transact-SQL)

  • Improving Load Performance

  • BCP Extras

  • Data Transformation Services (DTS)

  • DTS Architecture and Concepts

  • Package Execution Utilities

  • Running the DTS Wizard

  • DTS Designer

  • A Bit More on Metadata

The Bulk-Copy Program (BCP) is like an old friend to anyone who needs to get data in to (import) SQL Server tables from flat files or get data out of (export) SQL Server tables in to flat files. In fact, it is more like a warm security blanket because of the ease with which large amounts of data can be loaded or unloaded and the extreme reliability ...

Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.