1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Dropped lines when NULL ascii value in text file

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

  1. daiondoroga

    daiondoroga New Member


    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

    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