We have just had a Data truncation error in Azure Data Factory
\" from dbo.table ;"
},
"sink": {
"type": "AzureSqlSink",
"preCopyScript": "TRUNCATE TABLE dbo.table",
"disableMetricsCollection": false
},
"enableStaging": false,
"dataIntegrationUnits": 2
}
But you don't get any information as to what column has caused the problem
We would have to go back to the source table to do a search on maximum characters before going back and changing. This would take a while because we have to get another team involved.
Is there any way we can get this extra information into the error
I think its shipped in SQL Server 2019 possibly but we really need this in Azure Data Factory


