1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Dropped lines when NULL ascii value in text file

Discussion in 'SQL Server' started by daiondoroga, Aug 12, 2006.

  1. daiondoroga

    daiondoroga New Member

    Joined:
    Aug 12, 2006
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    0
    Hello,

    SQL SERVER 2000:
    My problem is that I have to process a special text file every day which contains 0 ASCII values to separate fields. The DTS import program drops everything after the ascii 0 value in the row, but of course I need the entire row with all fields.
    So how can I prevent the text file import task from dropping everything after the 0 ascii value?

    Could you help me in this?

    Thank you
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,285
    Likes Received:
    364
    Trophy Points:
    83
    ASCII value of NULL is 0 i.e. '\0' so if you are reading from a file each field will come as one line or string so you re read it and you should get the next field.
     

Share This Page