We have just had a Data truncation error in Azure Data Factory
\" from dbo.table ;"
"preCopyScript": "TRUNCATE TABLE dbo.table",
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