BULK INSERT Failing Due to Unexpected End of File - Help!

[faust13]

I'm trying to do a BULK INSERT from a file. Everytime I execute the SQL I get "Bulk Insert: Unexpected end-of-file (EOF) encountered in data file."

SQL:

BULK INSERT DB.Tbl
FROM 'c:\source.txt'
WITH
(
FIELDTERMINATOR = '|',
ROWTERMINATOR = '|^|',
KEEPNULLS
)

Source File Format:

data|data|Data|blah|^| ----------------------------------------
Is George Lucas Kidding...

 

[fluteplr]

Control-Z ascii value 26, is sometimes considered an end of file (eof) character. You might want to load your text file into an ascii editor and search for that character.

 

[faust13]

I had a space at the end of the file that was hosing the BULK INSERT.

Thanks! ----------------------------------------
Is George Lucas Kidding...