Kevin,
Bulk insert is fairly unforgiving, and pretty obtuse with the errors it spits up.
>Actually I just realized that I think I missed some columns in the CREATE TABLE, so the data in those column(s) is ending up in the Source_File, and is probably overflowing it.