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
Hey @JigneshShah-3584,
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
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
6 people are following this question.
