Post reply

BULK INSERT with ANSI PADDING OFF = 1 space?

  • November 3, 2005 at 9:10 am

    #74956

    I am using BULK INSERT to load a delimited text file into a database with ANSI PADDING OFF. All trailing spaces are truncated as expected for columns with data, but columns without data contain a single space. Any thoughts?

  • November 3, 2005 at 10:47 am

    #602194

    Is the KEEPNULLS option suitable?

    Daniel

  • November 3, 2005 at 11:00 am

    #602198

    Good thought, but it did not solve the problem. The fields have Allow Null Values enabled and there are no defaults set for them, but I tried it anyways to no avail.

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

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