BUG: Error 7399 When You Bulk Insert into Table with Column Default on a NUMERIC or DECIMAL Column (272292)



The information in this article applies to:

  • Microsoft SQL Server 7.0

This article was previously published under Q272292
BUG #: 58317 (SQLBUG_70)

SYMPTOMS

When you attempt to BULK INSERT into a table with a column default on a NUMERIC or DECIMAL column, the process will fail with the following error message:
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.

WORKAROUND

Use Bulk Copy Program (BCP) instead.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0.

Modification Type:MajorLast Reviewed:10/16/2002
Keywords:kbBug kbDSupport KB272292