bcp issue

12 Jan 2006 11:52 AM

Enric

Dear all,

I've got a little issue and I can't work out with it. Using BCP in order to
export the contains of a .dat file into a table:

C:\OFI0501>BCP abs..ABS_OF501 IN 20050726.DAT -e enric.txt -n -Sserver -U
us1 -Pdts1

SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Se encontrÃ³ un EOF inesperado en
un archivo de datos BCP
((suddenly error in bcp file))

How do I find out where the eof mark are?

Does anyone ever used or suffered this error?
Regards,

12 Jan 2006 12:03 PM

Rogas69

Hi,
EOF means End Of File - there's no particular code. Check if data format in
the file is correct
Peter

12 Jan 2006 12:10 PM

Enric

Thanks Rogas69. I knew it. Only was I wondering how to solve it of an
automatically way or something like that. Bearing on mind I've got 200 files
to load...
Anyway

Show quote

"Rogas69" wrote:

> Hi,
> EOF means End Of File - there's no particular code. Check if data format in
> the file is correct
> Peter
>
>
>

12 Jan 2006 12:59 PM

Erland Sommarskog

Enric (En***@discussions.microsoft.com) writes:
Show quote

> I've got a little issue and I can't work out with it. Using BCP in order
> to export the contains of a .dat file into a table:
>
> C:\OFI0501>BCP abs..ABS_OF501 IN 20050726.DAT -e enric.txt -n -Sserver
> -U us1 -Pdts1
>
> SQLState = S1000, NativeError = 0
> Error = [Microsoft][ODBC SQL Server Driver]Se encontró un EOF inesperado
> en un archivo de datos BCP
> ((suddenly error in bcp file))
>
> How do I find out where the eof mark are?
>
> Does anyone ever used or suffered this error?

Better to ask if there is anyone who have used BCP and never got any error.
It would at least be easier to count the hands.

These extrmely common error means that the data file does not match the
format specification. BCP finds that the file ends in the middle of a
record.

Since you are using native format, this means that the table definition
does not match the table definition. I have no idea what you expected.
Are the files really in native format? Native format means that data appear
in the field as they appear in SQL Server, that is binary.

Since you mentioned that you had 200 files, I would more expect a text
format...

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

12 Jan 2006 1:06 PM

Enric

f*ck..life, yep. I've came to the conclusion that the problem is that these
files were extracted from a 'unknown table' and now they want to load again
into another one...

Show quote

"Erland Sommarskog" wrote:

> Enric (En***@discussions.microsoft.com) writes:
> > I've got a little issue and I can't work out with it. Using BCP in order
> > to export the contains of a .dat file into a table:
> >
> > C:\OFI0501>BCP abs..ABS_OF501 IN 20050726.DAT -e enric.txt -n -Sserver
> > -U us1 -Pdts1
> >
> > SQLState = S1000, NativeError = 0
> > Error = [Microsoft][ODBC SQL Server Driver]Se encontrÃ³ un EOF inesperado
> > en un archivo de datos BCP
> > ((suddenly error in bcp file))
> >
> > How do I find out where the eof mark are?
> >
> > Does anyone ever used or suffered this error?
>
> Better to ask if there is anyone who have used BCP and never got any error.
> It would at least be easier to count the hands.
>
> These extrmely common error means that the data file does not match the
> format specification. BCP finds that the file ends in the middle of a
> record.
>
> Since you are using native format, this means that the table definition
> does not match the table definition. I have no idea what you expected.
> Are the files really in native format? Native format means that data appear
> in the field as they appear in SQL Server, that is binary.
>
> Since you mentioned that you had 200 files, I would more expect a text
> format...
>
>
> --
> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>