Error when trying to create folder in SharePoint Online using SSIS KingswaySoft

Copper Contributor


I wanted to migrate MS CRM Attachments to SharePoint Online.


So for that I am creating CRM records folder inside SharePoint Document Library using SSIS KingswaySoft.


But I am getting below error message when trying to create a folder:


The remote server returned an error: (500) Internal Server Error. (Error Type / Reason: InternalServerError, Detailed Message: {
"error": {
"code": "-2147024860, Microsoft.SharePoint.SPQueryThrottledException",
"message": "The attempted operation is prohibited because it exceeds the list view threshold."

It seems the issue is related to the “list view threshold limit in SharePoint”. As my SharePoint Document Library  already exceeds the list view threshold limit, which is 5000 items:




So can you please guide us if possible on how to handle the above issue from SSIS? OR is there any configuration needed on SharePoint side.


FYI, I am able to create folder in the above SharePoint Document Library via "Manually" and "Power Automate".


Any help will be appreciated!




0 Replies