Forum Discussion

AJAJ's avatar
AJAJ
Icon for Helper IV rankHelper IV
7 months ago

Same SQL Source table - ADF Copy Activity Succeeds but Fabric Copy Activity Fails- Auto create table

Hi there,   I'm using dynamic query to loop thru processing multiple tables. Source is SQL Server. Same table / Same query / Same SQL Source - Older ADF copy activity runs successfully. Fabri...
Need Help
pipelines
tayloramy's avatar
tayloramy
Icon for Super User rankSuper User
7 months ago

Hi AJAJ, 

 

The error is pretty clear: String or binary data would be truncated while reading column of type 'VARCHAR(20)'

You have an issue with column mappings, and data is being truncated. 

You need to adjust the column mappings to ensure that data is not getting truncated.