multiple lookup in copy activity

Question

Vineet S 1,390

Hi,

how to handle multiple lookup column as input in copy activity

Nandan Hegde 36,881 Reputation points MVP Volunteer Moderator

2024-07-06T03:29:44.9333333+00:00
Can you please provide some additional details as to :

what are the sources of your lookup activities?

what do you mean by having those as input for your copy activity? Explain more as to what your end goal is
Vineet S 1,390 Reputation points

2024-07-06T04:31:28.2333333+00:00

Look up on multiple tables on sql
Nandan Hegde 36,881 Reputation points MVP Volunteer Moderator

2024-07-06T04:46:28.3733333+00:00

Are all tables present within the Same SQL database? or they are spread across different databases? and what type of databases are those
Vineet S 1,390 Reputation points

2024-07-06T05:55:02.45+00:00

no only one database
Chandra Boorla 15,475 Reputation points Microsoft External Staff Moderator

2024-07-08T08:16:25.9933333+00:00

Hi @Vineet S

Just checking in to see if the below answer provided by @ Nandan Hegde helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

Nandan Hegde 36,881 Reputation points MVP Volunteer Moderator

2024-07-06T03:29:44.9333333+00:00

Can you please provide some additional details as to :

what are the sources of your lookup activities?

what do you mean by having those as input for your copy activity? Explain more as to what your end goal is
Vineet S 1,390 Reputation points

2024-07-06T04:31:28.2333333+00:00

Look up on multiple tables on sql
Nandan Hegde 36,881 Reputation points MVP Volunteer Moderator

2024-07-06T04:46:28.3733333+00:00

Are all tables present within the Same SQL database? or they are spread across different databases? and what type of databases are those
Vineet S 1,390 Reputation points

2024-07-06T05:55:02.45+00:00

no only one database
Chandra Boorla 15,475 Reputation points Microsoft External Staff Moderator

2024-07-08T08:16:25.9933333+00:00

Hi @Vineet S

Just checking in to see if the below answer provided by @ Nandan Hegde helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Nandan Hegde 36,881 MVP Volunteer Moderator

As all the tables are within the same database, you can create a SQL query joining all tables ( assuming they can be joined)

and use that query within the lookup activity/script activity .

Else you can use a for each activity and make the query dynamic and iterate over the queries via loop in meta data driven frameway

Chandra Boorla 15,475 Reputation points Microsoft External Staff Moderator

2024-07-09T08:59:00.3+00:00

Hi @Vineet S

Just checking in to see if the below answer provided by @ Nandan Hegde helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Rajat Lalzare 20 Reputation points

2024-12-11T10:55:26.0866667+00:00

Can you suggest an efficient approach? I want to do a copy data activity where my Tables are on different databases and servers. I am using an Azure SQL database as a warehouse where all the tables will be copied.