Home Forums SQL Server 2008 SQL Server 2008 Administration Bulk Insert text file into SQL table RE: Bulk Insert text file into SQL table

  • August 6, 2013 at 12:51 pm

    #1639075

    i've seen that a few times, that nul character is CHAR(0), and a great example of why you need a little better text editor; plain old windows notepad won't show you that kind of issue.

    i've typically done a find and replace of those chars to fix the files themselves before i import them.

    should those NUL values be treated as commas? spaces? maybe go back to teh source and tell em it's nto a good format?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!