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?