Using native format bcp to load data in an improperly 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 that use the bcp API in native mode.
Native format bcp is intended for high-speed data transfer between identically defined tables. To achieve the optimum transfer rate, few checks are performed regarding data formatting. The user must ensure the table is correctly defined or else use character format bcp.
Correct table definition includes the correct number of columns, datatype, length, and NULL status.