I've imported a number of formatted .txt files using DTS just by inserting the entire row into a record and splitting it up once it landed in my database.

Is there a trigger on that table? Try disabling the trigger prior to running the script.