Before You Transfer

Prepare the command and the data for transfer before using bcp in.

To use either fast or fast-logged bcp, set select into/bulkcopy/pllsort to true. For example, to turn on this option for the pubs2 database, enter:
sp_dboption pubs2, "select into/bulkcopy/pllsort", true

To use fast bcp, remove indexes on the target table.

In addition:

Related concepts
bcp Modes
Related reference
bcp Modes
Fast, Fast-logged, and Slow bcp