Error 0xc0202009: Data Flow task 1:ssis error code dts_e_oledberror. An OLE DB error occurred.

It turned out to be a varchar field that appeared "and" and other special characters.

This is not a problem in the INSERT statement, but using an import export will cause an error.

Finally, it is important to note that the import and export uses the Bulkinsert method, each time it is possible to read a large segment (multi-line record processing together), if there are errors in this batch of data, then

The program will report an exception, the record of the error is often not the last record of the next record.

So if there's an error in this line of 856123, you can look for it in the 2000 range above it.

Error 0xc0202009: Data Flow task 1:ssis error code dts_e_oledberror. An OLE DB error occurred.