Adf script activity inner join from different linked service

Question

Adf script activity inner join from different linked service

Pankaj Joshi 391

I have two Iinked service1 - table " Ext_emp" and linked service2 - table "Int_emp". Now I want to combine both this table using inner join and update table "Ext_emp" column " Processed_Flag* based on matching row value. Is it possible to write update query in adf script activity to inner join table from different linked service? Else what is the alternate approach?

Venkat Reddy Navari 5,255 Reputation points Microsoft External Staff Moderator

2025-08-07T12:35:02.6433333+00:00

Pankaj Joshi 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

Your answer

Venkat Reddy Navari 5,255 Reputation points Microsoft External Staff Moderator

2025-08-07T12:35:02.6433333+00:00

Pankaj Joshi 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,396 MVP Volunteer Moderator

Script activity can only map /connect to 1 source/linked service at a time.

So one cannot join 2 different tables from diff sources via a script activity.

You can use ADF dataflow activity and use Join transformation :

https://learn.microsoft.com/en-us/azure/data-factory/data-flow-join

Share via

Adf script activity inner join from different linked service

1 answer

Your answer