BCP FAQ

The following section lists some of the common questions asked by DBAs about BCP:

Q1: How can I use BCP to import data from a 6.x version of SQL Server? Whenever I use BCP to import the data, I get various ODBC errors.
A1: Use the -V (60|65) option when importing data from a 6.x version of SQL Server. The SQL Server 2000 version of BCP uses ODBC to interface with SQL Server, whereas previous versions used DB-Library. ODBC treats data types differently from DB-Library.
Q2:When should I use BCP instead of DTS?
A2: The main reason to use BCP is performance. BCP can import and export data faster than DTS. If performance is not an issue, I recommend using DTS. DTS is easier to use and is more flexible than BCP.
Q3:Which file formats are supported ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, 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.