I need some help with this problem it's driving me crazy. I have a Bulk Insert statement which uses a format file. Everything works fine except the application I'm exporting the text file from creates a eof marker at the end of the text file. This cause the Bulk Insert to fail with an unexpected end-of-file. I know it's the eof market because if I remove it everthing works fine. I cannot edit the file every time because I need to execute this statement several hundred times. Does anybody know of a way to deal with this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Bulk Insert can't handle eof marker
- Thread starter stanky23
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question