trailing spaces in import file

  • I keep getting "error reading destination table name for source column xx in format file". I get this error whenever the row ends a space characters before the carriage return/newline.

    In the format file (and the table) I have made sure the last field length is specified long enough to accomodate the spaces - but it doesn't seem to matter. I have also tried setting the row terminator to space, but that doesn't work either.

    Does anyone have any ideas that could help me out?? Thanks!

  • I should mention I'm using bulk insert.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply