question

Anandazure-0965 avatar image
0 Votes"
Anandazure-0965 asked HimanshuSinha-MSFT commented

Azure data factory

How to do truncate load from SharePoint list to destination table

azure-data-factoryazure-synapse-analytics
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

1 Answer

SaurabhSharma-msft avatar image
0 Votes"
SaurabhSharma-msft answered

Hi @Anandazure-0965,

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 -
137829-image.png

Please let me know if any questions.

Thanks
Saurabh


image.png (68.3 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Anandazure-0965 ,

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

0 Votes 0 ·

@Anandazure-0965 ,

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

0 Votes 0 ·