If a table has indexes or triggers, a slower version of bulk copy is automatically used. For slow bulk copy:
You do not have to set the select into/bulkcopy.
Rules are not enforced and triggers are not fired, but defaults are enforced.
All data changes are logged, as well as the page allocations.
Indexes are updated as rows are copied in, and index changes are logged.
