UPSERT MERGE ISSUE

Rohit Kulkarni 676 Reputation points
2022-05-07T01:47:25.757+00:00

Hello Team,

I am trying to upsert the data from S4 Tables to SQL server tables dynamically i am selecting the tables .

Example: Out of 4 tables there is an issue with 1 table and for the rest of the tables the data is getting upserted.

199793-image.png
199720-image.png

For 1 table i am getting below mentioned.I am mentioning the steps i carried out

199875-image.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,341 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AnnuKumari-MSFT 30,101 Reputation points Microsoft Employee
    2022-05-10T09:05:54.147+00:00

    Hi @Rohit Kulkarni ,

    Thankyou for using Microsoft Q&A platform and thanks for posting your query.

    As I understand your question here, you are trying to perform merge on data in SQL server tables using Upsert option in copy data activity. However, it is failing with error for one of the tables. Please let me know if my understanding is incorrect.

    The error says 'Server is not responding'. This looks like an intermittent issue from source side. Could you please confirm if

    1. that's happening for the same table all the time ?
    2. If only that particular table is considered to be copied , others being inactive for one run, is that still failing?
    3. What is selected in the keycolumns for upsert functionality?

    Looking forward for your response. Thanks !