Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Unexpected EOF on Bulk Insert

Author  Topic 

davidpardoe
Constraint Violating Yak Guru

324 Posts

Posted - 2001-08-13 : 12:22:07
I have been getting an unexpected EOF a the very end of a Bulk Insert of a file from a particular data supplier. After lots of investigation I finally discovered that the reason is that there is an ASCII character 26 at the end of the file (Substitute? character).

Is there any way I can get Bulk Insert to ignore this character or will I have to strip out the character from the source file?

   

- Advertisement -