Copy data from one sql table to a staging table using Azure Data Factory- Copy Activity

Question

I need to copy data from one sql table to another staging table

Currently, I am using copy activity and in the source I am calling a procedure with some parameters , and in the sink I am looking to dump the output of the procedure into a staging table.

However, I am not able to find a way to add the sql table name in the source.(I have created the staging table in the DB.)

Is there any way, to dump the data into the staging table using Copy Activity?

Regards

Answer 1

Hey @jigsm ,
In the copy activity :
Under Source :

under sink:
within dataset you can select the specific table in which you want to copy the data

On a side note: are both source and sink tables in same database?
If yes, you can have your logic implemented in a single SP and call the stored procedure activity

Answer 2

If you want to select your staging table where data has to be loaded, just create a new dataset pointing to that table.

----------

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