insert update strategy

Question

Hi,

How we can update and insert data using sp in adf copy activity ... i can see check box in sync option of copy activity but how to add in it...please help me with screenshot

Answer 1

Hi @Vineet S

Thanks for the question and using MS Q&A platform.

1. In the sink settings of the Copy Activity, you can select the stored procedure option. Here, you can specify the stored procedure that you want to use.
2. If your stored procedure requires parameters, you can specify them in the parameter mapping section.

Hope this helps! Let me know if you have any further questions.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 2

Not sure what your ask is here?

Do you want to upsert data into your sink via stored procedure?

If yes, you cab use Merge Statement or write your own SQL code to upsert within the SP