bulk insert error - Unexpected end-of-file (EOF)

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

Import/Export (DTS) and Replication (2000)

bulk insert error - Unexpected end-of-file (EOF)

Author

Topic

femig
Starting Member

5 Posts

Posted - 2004-05-25 : 06:01:54

this is my table called xxx

acctno varchar (20)
pincode varchar (50)
startdate varchar (50)
TransactType varchar (50)
SuccessFlag varchar (50)
NoOfMonths char (50)

this is a sample of the file batch_registration_update_20040324_193008.rpt)i am importing;

2348034058711|1193|20040522 19:07:16|N|S|3

this is the sql statement;

BULK INSERT adp2sql.dbo.[xxx] FROM 'D:\Site\xxx\batch_registration_update_20040324_193008.rpt' WITH (FIELDTERMINATOR ='|',ROWTERMINATOR ='\n')

i get the following 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.

any help please?

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2004-05-25 : 06:59:11

I have had this error many times before.
In most of the cases it was due to some funny character sitting in the file somewhere.

Browse the contents of the file to identify this.
You might find a file browser which allows you to view the hex values to be quite handy here.

Duane.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources