Bulk Insert: Unexpected end-of-file (EOF) encountered...

Hi to all,
I have a problem about a importation of a file *.csv with SQL Server,
through a bulk insert, called in a store procedure that a c# sw calls.
This is the description of the error:
-----
System.Data.SqlClient.SqlException =E8 stata individuata
Message=3D"Bulk Insert: Unexpected end-of-file (EOF) encountered in
data file.\r\nOLE DB provider 'STREAM' reported an error. The provider
did not give any information about the error.\r\nOLE DB error trace
[OLE/DB Provider 'STREAM' IRowset::GetNextRows returned 0x80004005:
The provider did not give any information about the error.].\r\nThe
statement has been terminated."
Source=3D".Net SqlClient Data Provider"
ErrorCode=3D-2146232060
Class=3D16
LineNumber=3D1
Number=3D4832
Procedure=3D""
Server=3D"ets3971"
State=3D1
StackTrace:
at System.Data.SqlClient.SqlConnection.OnError(SqlException
exception, Boolean breakConnection)
at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlExcep tion
exception, Boolean breakConnection)
at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(Tds ParserStateObje=
ct
stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
stateObj)
at
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlData Reader ds,
RunBehavior runBehavior, String resetOptionsString)
at
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(Command Behavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean
async)
at
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBeh avior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
method, DbAsyncResult result)
at
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbA syncResult
result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at sarbox.Default.LoadFlux_Click(Object sender, EventArgs e) in
c:\Inetpub\wwwroot\Zarbox2.2\SoxAdmin\Default.aspx.cs:line 1509
---

Th@nks to all

AB@

Re: Bulk Insert: Unexpected end-of-file (EOF) encountered...

AB@ (b.aharon44@gmail.com) writes:
> I have a problem about a importation of a file *.csv with SQL Server,
> through a bulk insert, called in a store procedure that a c# sw calls.
> This is the description of the error:
> -----
> System.Data.SqlClient.SqlException è stata individuata
> Message="Bulk Insert: Unexpected end-of-file (EOF) encountered in
> data file.\r\nOLE DB provider 'STREAM' reported an error. The provider
> did not give any information about the error.\r\nOLE DB error trace
> [OLE/DB Provider 'STREAM' IRowset::GetNextRows returned 0x80004005:
> The provider did not give any information about the error.].\r\nThe
> statement has been terminated."

Unfortunately, the information you posted is not sufficient to help
you. Could you please post:

1) The BULK INSERT statement.
2) Any format file you are using.
3) A short sample of the data file.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

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

Re: Bulk Insert: Unexpected end-of-file (EOF) encountered...

On 17 Apr, 23:40, Erland Sommarskog wrote:
> AB@ (b.aharo...@gmail.com) writes:
> > I have a problem about a importation of a file *.csv with SQL Server,
> > through a bulk insert, called in a store procedure that a c# sw calls.
> > This is the description of the error:
> > -----
> > System.Data.SqlClient.SqlException =E8 stata individuata
> > Message=3D"Bulk Insert: Unexpected end-of-file (EOF) encountered in
> > data file.\r\nOLE DB provider 'STREAM' reported an error. The provider
> > did not give any information about the error.\r\nOLE DB error trace
> > [OLE/DB Provider 'STREAM' IRowset::GetNextRows returned 0x80004005:
> > The provider did not give any information about the error.].\r\nThe
> > statement has been terminated."
>
> Unfortunately, the information you posted is not sufficient to help
> you. Could you please post:
>
> 1) The BULK INSERT statement.
> 2) Any format file you are using.
> 3) A short sample of the data file.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodt=
echnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/=
previousversions/books.mspx

I have risolve it - thanks

Re: Bulk Insert: Unexpected end-of-file (EOF) encountered...

This looks resolved, but I've experienced this problem before.
Resolution occured in one of three ways:

1) We sometimes get files that are cut off prematurely and a line
will only be a fraction completed. This will fail a bulk-insert.
2) Sometimes an extra carriage return is at the end of the file.
I've seen this fail the bulk-insert with an Unexecpected EOF message.
3) Sometimes I just couldn't figure out the answer and using DTS
instead of bulk insert resolved the problem.

I hope that helps somebody. :D

-Utah