question

RohitKulkarni-6062 avatar image
0 Votes"
RohitKulkarni-6062 asked PRADEEPCHEEKATLA-MSFT commented

Copy Activity

Hello Team,

I want to transfer data from Source to Destination from Multiple tables .Is it possible to do in single copy activity.


Thanks in Advance

RK

azure-data-factory
· 2
5 |1600 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.

Hello @RohitKulkarni-6062,
Just checking in to see if the below answer provided by @NandanHegde-7720 helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·

Hello @RohitKulkarni-6062,

Following up to see if the below suggestion was helpful. And, if you have any further query do let us know.
Take care & stay safe!

0 Votes 0 ·

1 Answer

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 answered NandanHegde-7720 commented
· 4
5 |1600 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.

This will be for whole tables in the schema.

Example. If there are 10 tables in One schema. I need to transfer the data only 6 tables then.

Thanks in advance
RK

0 Votes 0 ·

Hey, you can create a parameter of type array with all the table names which you want to copy and use it in for each activity.
The above link is just a reference link ☺️

Hope this clarifies your query!

0 Votes 0 ·

Hello Nandan,

I got clarified transferring data from Multiple tables.

If we upload multiple tables there will be impact on slow performance of uploading the data. So what is the best practice for the configuration of Azure SQL DB
example. How much it must be DTU.

Thanks in advance

Regards
RK

0 Votes 0 ·
Show more comments