Go4Expert

Go4Expert (http://www.go4expert.com/)
-   SQL Server (http://www.go4expert.com/forums/sql-server-forum/)
-   -   Dropped lines when NULL ascii value in text file (http://www.go4expert.com/forums/dropped-lines-null-ascii-value-text-file-t1182/)

daiondoroga 12Aug2006 20:00

Dropped lines when NULL ascii value in text file
 
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

shabbir 13Aug2006 08:21

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 03:23.