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
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.
