See if you can get it working using bcp interactively and then use the generated format file with BULK INSERT.

--Jonathan