Dropped lines when NULL ascii value in text file

daiondoroga's Avatar
Go4Expert Member
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
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
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.