not possible to use SharepointAdapter in SSIS Design Mode

Sep 23, 2011 at 2:00 PM


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 [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."

I have tried to set different batch size...

Any help or advice ?


Sep 27, 2011 at 2:49 PM

That is a generic Sharepoint error.  Can you. Visit the SharePoint site with your credentials? Is there some weird data on the site? Try Removing columns in advanced tab output columns to narrow down the issue. How many columns are you trying to return?

Sep 27, 2011 at 3:02 PM


Yes I have the credentials for the site. Actually, there is a lot of column retrieved, I will try first will retrieving only one column.