bulk insert

[Guest_imported]

hi guys

BULK INSERT test.dbo.branch FROM 'c:\branch.dbf' once i need your help
when i execute that bulk insert statement it gives error
************************************************************
Server: Msg 4832, Level 16, State 1, Line 1
Bulk Insert: Unexpected end-of-file (EOF) encountered in data file.
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'STREAM' reported an error. The provider did not give any information about the error.
The statement has been terminated.
**********************************************************

 

[Tim1]

Hiya,

I think that it means that a field terminator has been found in the wrong place. You would need to check the source data that you are entering for a field seperator (I think dbf files are delimited with a tab, but it is a while since I worked with them) in the wrong place, meaning that the row is the wrong size for the target table.

HTH

Tim