Forum Discussion
tejarebb
Nov 08, 2023Copper Contributor
ADF validation failing for Azure SQL Sink upsert when fault tolerance (skip rows) enabled
Hi all, I have been getting this error since yesterday, "Fault tolerance is not supported when using azure sql database upsert method." There have been published versions of the data factory wher...
LukeFletcher
Nov 10, 2023Copper Contributor
tejarebb I have been getting the same thing across mutiple clients. Whilst I dont know why yet,
I have had to work around by removing the fault tolerance setting as higlighted in red below
If anyone has an explanation that would be great 🙂