INF: Native Mode BCP to Mis-Defined Table Loads Incorrectly

ID: Q112003

The information in this article applies to:

Microsoft SQL Server for OS/2, version 4.2
Microsoft SQL Server version 4.2x

SUMMARY

Using native mode bulk copy to load data in a mis-defined table can cause the table to be loaded incorrectly. The incorrect loading might appear as an unusual formatting of data in the target table. This would also apply to client tools which use the BCP API in native mode, such as SQL Object Manager.

MORE INFORMATION

Native mode bulk copy is intended for high-speed data transfer between identically defined tables. To achieve the optimum transfer rate, there are few checks performed regarding data formatting. The user must ensure the table is correctly defined or else use character-mode bulk copy. Correct table definition includes the correct number of columns, datatype, length, and NULL status.

Additional query words: BCP Windows NT


Keywords          : kbtool SSrvBCP SSrvWinNT 
Version           : 4.2 | 4.21
Platform          : OS/2 WINDOWS 
Issue type        :

Last Reviewed: March 18, 1999