We are trying to connect a SQL Server database on a remote server to a corporate SharePoint site. From the SQL Server we created a SharePoint List Source and an OLE DB Destination. However, we get the following error and cannot find a solution on the web. Any help or ideas will be greatly appreciated.
"[SharePoint List Source [1]] 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."
We have ensured we are using the 32bit adapter and have limited the results to one field, which we read as a resolution on a previous post, but still no luck!