I have a source file in ADLS Gen2 and target as sql db. But when im going to copy the data into SQL table, the below error it is giving
Failure happened on ‘Sink’ side. ErrorCode=SqlOperationFailed,’Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed. Please search error to get more details.,Source=Microsoft.DataTransfer.ClientLibrary,”Type=System.InvalidOperationException,Message=The given value of type String from the data source cannot be converted to type nvarchar of the specified target column.,Source=System.Data,”Type=System.InvalidOperationException,Message=String or binary data would be truncated.,Source=System.Data,’

Need answer for that