Bcp EOF character -
11-10-2003
, 09:19 AM
When I import a file to a database via bcp command an
error occurs. "Unexpected EOF encountered in BCP data-file"
The data file ends with an newline made by "enter" key on
keyboard.I use the format fil to ajust number of fields in
datafile <> db table.
Everything works fina apart this.
Is there a special character to end with?
data file (Funlayer.txt):
text1 003
Se tabell1 4.7625
I ån är en ö 7.0000
format file(bcp.fmt)
8.0
3
1 SQLCHAR 0
0 "" 1 id ""
2 SQLCHAR 0
0 "\t" 2 MNummer
Finnish_Swedish_CI_AS
3 SQLCHAR 0
0 "\r\n" 3 InnerDiam ""
command line:
bcp DB1..FunLayer in Funlayer.txt -Slocalhost -T -fbcp.fmt |