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