Bulk loading with large amounts of data requires strategy. The Data Loading Performance Guide for SQL Server 2008 and SQL Server 2005 is a very useful document.
Highlights
Understanding Minimally Logged Operations
Trace Flag 610 (sql server 2008)
Summarizing Minimal Logging Conditions
Bulk Load Methods
Integration Services Data Destinations
BCP
BULK INSERT
INSERT ... SELECT
SELECT INTO
Choosing Between Bulk Load Methods
Data Compression and Bulk Load
Other Minimally Logged and Metadata-Only Operations
Solving Typical Scenarios with Bulk Loading
Optimizing Bulk Load
