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...
tejarebb
Nov 16, 2023Copper Contributor
Unfortunately, MS told that the feature never worked in the first place for upsert operations. I don't think there's any alternative other than disabling it
JarWest
Nov 16, 2023Copper Contributor
That's very bizarre. It's been working for us perfectly fine until I believe around the 7th. We aren't making a new pipeline on our end, we're just trying to update an existing pipeline that we've had for, to my knowledge, at least 3 months. We're trying to update the mapping to add a new column.