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.