Dear all,

I encountered a problem regarding the captioned issue.
The situation is that I am importing data from a data file (either in txt,
dat or xls format) to SQL server 2000, using both bcp utility and DTS
Import/Export Wizard.

Error messages received when i use the 2 methods to import the data. The one
for bcp is stated as below:
================================================== ================================
SQLState = S1000, Native Error = 0
Error = [Microsoft][ODBC SQL Server Driver] Unexpected EOF encountered in
BCP data-file
================================================== ================================

The one for DTS Import/Export Wizard is stated as follows:
================================================== ================================
Error at Destination for Row number 168. Error encountered so far in this
task:1.
================================================== ================================

It is believed that both error messages incdicate the same error. Moreover,
I have already defined the field and row terminators and tried controlling
the last row of the data file by adding -L169 (a total of 169 rows of data)
when using bcp method. However, it still didn't work out. How should I solve
the problem?

I have read several articles from MS KB, but they all are not relevant to my
case.

Looking forward to hearing from your replies. A million thx in advance.

Best Regards,
KL

I would open the file up in a Hex editor and see if you can detect the
prolem with the error rows.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"KL" <karenkk.lee (AT) gmail (DOT) com> wrote