Populate sink table with new column values

Question

Populate sink table with new column values

Raj0125 511

@ AnuragSharma-MSFT

Hi ,

I am trying to achieve the below requirement in ADF.Please suggest on this

https://learn.microsoft.com/en-us/answers/questions/832605/duplicate-records-is-populating.html?childToView=836113#answer-836113

HimanshuSinha 19,547 Reputation points Microsoft Employee Moderator

2022-05-24T16:45:25.313+00:00

Hello @Raj0125 ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu
HimanshuSinha 19,547 Reputation points Microsoft Employee Moderator

2022-06-02T19:54:23.167+00:00

Hello @Raj0125 ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others .
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread .
Thanks
Himanshu

1 answer

Your answer

HimanshuSinha 19,547 Reputation points Microsoft Employee Moderator

2022-05-24T16:45:25.313+00:00

Hello @Raj0125 ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu
HimanshuSinha 19,547 Reputation points Microsoft Employee Moderator

2022-06-02T19:54:23.167+00:00

Hello @Raj0125 ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others .
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread .
Thanks
Himanshu

Answer 1

Hello @Raj0125 ,
Thanks for the question and using MS Q&A platform.

As we understand the ask here is run the SQL query in the thread posted using ADF and I am guessing you want to insert that into a SQL table , please do let us know if its not accurate.

You can use the copy activity in ADF to get his done . You can read about this here : https://learn.microsoft.com/en-us/azure/data-factory/copy-activity-overview

Please do let me if you have any queries.
Thanks
Himanshu

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
Want a reminder to come back and check responses? Here is how to subscribe to a notification
- If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Share via

Populate sink table with new column values

1 answer

Your answer