Microsoft KB Archive/324122

= BUG: BULK INSERT Fails with Error Message 7399 =

Article ID: 324122

Article Last Modified on 7/22/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q324122



BUG #: 58262 (sqlbug_70)



SYMPTOMS
A BULK INSERT operation may fail with error message 7399 if the size of the input file is 65536 bytes or a multiple of 65536 bytes (for example, 3473408 bytes).

The error message that you receive is:

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.

Additionally, you may receive this error message:

Server: Msg 4866, Level 17, State 66, Line 1 Could not bulk insert because column too long in data file. Make sure FieldTerminator and RowTerminator were specified correctly.

NOTE: You can receive error message 7399 in other situations. Make sure that your conditions match the symptoms in this article.



WORKAROUND
To work around this problem you can either:
 * Use the bcp utility. The bcp utility works with both character and native file types.

-or-


 * Use Data Transformation Services (DTS).



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
If you set trace flag 7300 on with the DBCC TRACEON (7300) command, you can see additional information, such as this error message:

OLE DB error trace [OLE/DB Provider 'STREAM' IRowset::GetNextRows returned 0x80004005: The provider did not give any information about the error.]. Msg 7399, Level 16, State 1, Server, Line 1

OLE DB provider 'STREAM' reported an error. The provider did not give any information about the error. The statement has been terminated.

The  in the error message refers to your specific environment.

Keywords: kbbug kbpending KB324122

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.