Getting error with Bulk copy activity

Sheryansh93

I am getting the error BCP send row failed: string data right truncation

When I have checked the max length in each column it's well within the limits

Also when it is done one row at a time there is no error only during bulk copy, we are getting an error

carterluke

The "BCP send row failed: string data right truncation" error often occurs due to hidden issues with the data, like trailing spaces or special characters exceeding the defined column limits during bulk copy. Even though individual rows work, bulk operations handle data differently. Double-check your data for any unexpected characters or inconsistencies, and ensure all data matches the exact column definitions, including lengths and types