How to add a Joing Query for pipeline Source

Question

Hi Team,

Currently i have configure integration Runtime and link services, After then I have to setup a join query for a pipeline source area as per below snap, but our concern is when i create a source connection i'm only allow to select one table but join quarry have a two tables, but that other table already available on same link service connection and same schema, So Can i create a join query as per below snap? and can i extract a data using below join Query? Could you please advise on this?

Answer 1

Hi Mahesh,

You can copy data from multiple tables using a query. To do so, you will have to do the following :

1. In your dataset settings, select "None" for table, as shown below :

2. In your copy activity source tab, write the query you want to in the "Query" text field as shown below :

Hope this helps.