Insert in batches. See an example that @Kristen had posted in this thread.
Alternatively, as @dennisc suggested, use bcp or bulk-insert.