Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Unanswered

Kingswaysoft SSIS-SharePoint threshold Error "task The attempted operation is prohibited because it exceeds the list view threshold SharePoint Destination"

(0) ShareShare
ReportReport
Posted on by 5

Hi Team,

 We are facing issue while importing files from source as SharePoint folder and destination is Dynamic CRM Destination. While running the SSIS task, we are getting error -The attempted operation is prohibited because it exceeds the list view threshold (SSIS Integration Toolkit for Microsoft SharePoint, v22.1.1.35601 - DtsDebugHost, v15.0.2000.261)”.SharePoint threshold limit is 5000.

 My sharePoint site folder contains 163597 files.

 To resolve the error I am adding the filter criteria Batch size is 20 and checked checkbox Retrieve First Page Only as below screenshot, looks like this filter is not working as I am getting same threshold error:

Can you please guide how to handle the SharePoint file threshold error in SSIS tasks?

 

 

Regards,

Pauravi

 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans