question

JigneshShah-3584 avatar image
0 Votes"
JigneshShah-3584 asked ·

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

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

azure-data-factory
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 answered ·

Hey @JigneshShah-3584,
In the copy activity :
Under Source :
77014-sp.png


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

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


sp.png (28.9 KiB)
sink.png (45.1 KiB)
·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered ·

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

77072-image.png




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


image.png (19.6 KiB)
·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.