adf-sql bulk copy failed

KEERTHANA JAYADEVAN 66 Reputation points
2022-09-27T05:33:29.763+00:00

@HimanshuSinha-msft
Failure happened on 'Sink' side. ErrorCode=SqlBulkCopyInvalidColumnLength,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=SQL Bulk Copy failed due to receive an invalid column length from the bcp client.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Data.SqlClient.SqlException,Message=The service has encountered an error processing your request.
This is what i am getting and i checked thoroughly and all my column lengths are matching

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,712 questions
{count} votes