Azure data factory

Anandazure 46

How to do truncate load from SharePoint list to destination table

HimanshuSinha-msft 19,376 Reputation points Microsoft Employee

2021-11-10T18:42:58.477+00:00

Hello @Anandazure ,
We haven’t heard from you on the last response from @Saurabh Sharma 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

1 answer

Saurabh Sharma 23,676 Reputation points Microsoft Employee

2021-10-05T19:36:16.65+00:00

Hi @Anandazure ,

Thanks for using Microsoft Q&A !!

Is your destination a SQL Table. If yes, then you can take use of Pre-copy script to truncate the table before loading data from a SharePoint List. Please see the screenshots below -

Please let me know if any questions.

Thanks
Saurabh
Please sign in to rate this answer.
Saurabh Sharma 23,676 Reputation points Microsoft Employee

2021-10-18T19:30:28.72+00:00

@Anandazure ,

I have not heard back from you. Did my answer solve your issue? If not, please let me know how I may better assist.

Thanks
Saurabh

Saurabh Sharma 23,676 Reputation points Microsoft Employee

2021-10-23T00:56:55.257+00:00

@Anandazure ,

We haven't heard back from you. In case if you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks
Saurabh
Sign in to comment