I need to use this tool to retrieve a list from sharepoint.
I have installed it via the msi installer, I have in the assembly list "SharePointListAdapters", and can retrieve the tool in the toolbox on SSIS.
When I insert the URL, I see the fields in the column mapping tab.
But when I execute, I have the message :
"[SharePoint List Source ] Error: 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."
I have tried to set different batch size...
Any help or advice ?