One way to find the issues with the data is try inserting a record in the table. BCP out ( probably using '~' as delimitor ) and compare the output...