ADF - Activity used to insert data into database table

Question

My requirement is to insert records into database tables from pipeline
To achieve this I am using Lookup activity there selecting Query and writing insert query by this I am able to insert but as per documentation I observe that Lookup activity is not appropriate to use for Insert data can you please guide how can I achieve this

Answer 1

Hey @Kavitha Lakshmi Angajala ,
Since the source data is from variables and not from an actual data source, I would prefer the below options rather than a copy activity: and most preferably SP activity :

1. Stored procedure activity
   Create a stored procedure within your database with input parameters as the variable values and call stored procedure activity in ADF

2) Lookup activity

Answer 2

From where do you want to insert the data?

To copy the data, ideally Copy activity has to be used

---

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav