Hello @Mutthuluru Yashwanth Sai,
This error (String or binary data would be truncated) generally means a type mismatch between source and target. The max length of the target is less than the actual source data. As a result, data is truncated, returning this error.
Please try the below.
- Check the length of actual data in the source and the length of the column in the target table.
- The max length of the intermittent external table in polybase(behind the scenes, PolyBase creates an External Table) is nvarchar(4000). Therefore, if the max length of the source column is greater than nvarchar(4000), polybase option can’t be used.
If this is your case, please try to use the bulk insert option, not the polybase or copy into option in copy activity.
[https://learn.microsoft.com/en-us/azure/data-factory/connector-azure-sql-data-warehouse?tabs=data-factory#use-polybase-to-load-data-into-azure-sql-data-warehouse