Forum Discussion
QUESTION::COPY DATA::UPSERT FAIL
The source is an on-prem SQL Server, and the destination is a lakehouse table. I use a Copy data activity pointing to the lakehouse SQL endpoint in order to get access to the Upsert option.
Ca...
I'm facing the same issue, I tried both lakehouse and warehouse , Both returned same error. I suspect its the issue Azure sql db on warehouse. Will enabling staging help ?
No. I have a support ticket open since one month ago. The product team is still debugging and hasn't come back with a fix yet.