Unanswered: 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?
Yes, the importing process continues..and the DTS import task just drops the remaining part of the line after the ASCII 0 character.
So all the rows that contain a 0 ASCII character at some point will be just partly imported. I need to somehow ignore this 0 ASCII character..
I don't know of any way to get DTS to process a file containing NUL values. You'll probably need to pre-process those into some other character (I'd suggest using TAB or 0x09) using a client-side tool (I'd pick Perl as my first choice, and C as my second, but I'm a geek).