BUG: BCP: Err Msg: Attempt to Bulk-copy an Oversized Row

ID: Q99923

The information in this article applies to:

BUG# OS/2: 8678 (4.2)
       NT: 8679 (4.2)

SYMPTOMS

When doing a bulk copy from an ASCII data file into SQL Server with a char column that does not allow nulls, and where the data file does not have data for that column (intending to insert default value bound to the column), the rows are copied successfully, but the following message is displayed once for each row: 


   Attempt to bulk-copy an oversized row to the SQL Server.

This happens only if the column is a char datatype and is defined as not null and the data file does not contain any data for that column. This does not happen if the column is of type varchar.


WORKAROUND

You can create a temporary table with the char column defined as allowing nulls, BCP in data into that table and then insert data from the temp table to the actual table with non-null char column using an INSERT statement.

Another workaround is to define the column as varchar instead of char.


STATUS

Microsoft has confirmed this to be a problem in SQL Server version 4.2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available

Additional query words: bcp bulk copy program error err msg errmsg alert 


Keywords          : kbtool SSrvBCP kbbug4.20 SSrvWinNT 
Version           : 4.2 | 4.2 | 4.2
Platform          : MS-DOS OS/2 WINDOWS 
Issue type        :

Last Reviewed: March 23, 1999