Dropped lines when NULL ascii value in text file
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?
Re: Dropped lines when NULL ascii value in text file
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.
|All times are GMT +5.5. The time now is 22:52.|