System.ServiceModel.FaultException: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.

Feb 27, 2013 at 9:58 AM
When querying a SharePoint list using the SharePoint List Adapter in SSIS, I get the following message:

Error: 0xC0047062 at SharepointDocument Population Staging, SharePoint List Source [4444]: Microsoft.Samples.SqlServer.SSIS.SharePointUtility.SharePointUnhandledException: Unspecified SharePoint Error. A possible reason might be you are trying to retrieve too many items at a time (Batch size) ---> System.ServiceModel.FaultException: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.

It would be nice to be able to see the InnerException detail here, is that possible?

Thanks,

Ken
Jan 10, 2014 at 11:00 PM
I know this is very late, but others may see this. The same error will occur if you have more than 8 columns that Microsoft considers lookup columns, which can include workflow status, people and others. I upped the central admin throttling to increase it and it worked for me after getting the above error for a while.

PS
Used fiddler to watch the traffic to the sharepoint site to get a better answer about the error.