Sharepoint List comp to Excel Destination error

Jul 19, 2010 at 8:47 AM

Hi there,
      I tried using the component to export data from a list to an Excel Sheet.
But i keep getting error like below:


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.Dispatcher.NetDispatcherFaultException:
The formatter threw an exception while trying to deserialize the message: There was an error while trying to deserialize parameter
http://schemas.microsoft.com/sharepoint/soap/:GetListItemsResponse.
The InnerException message was 'There was an error deserializing the object of type Microsoft.Samples.SqlServer.SSIS.SharePointUtility.ListsService.GetListItemsResponseBody. The 'maximum bytes per Read operation' quota (4096) has been exceeded while reading XML data.
Long element start tags (consisting of the element name, attribute names and attribute values) may trigger this quota.
This quota may be increased by changing the MaxBytesPerRead property on the XmlDictionaryReaderQuotas object used when creating the XML reader.
Line 46, position 1235.'.  Please see InnerException for more details. ---> System.Runtime.Serialization.SerializationException:
There was an error deserializing the object of type Microsoft.Samples.SqlServer.SSIS.SharePointUtility.ListsService.GetListItemsResponseBody.
The 'maximum bytes per Read operation' quota (4096) has been exceeded while reading XML data.
Long element start tags (consisting of the element name, attribute names and attribute values) may trigger this quota.
This quota may be increased by changing the MaxBytesPerRead property on the XmlDictionaryReaderQuotas object used when creating the XML reader.
Line 46, position 1235. ---> System.Xml.XmlException: The 'maximum bytes per Read operation' quota (4096) has been exceeded while reading XML data.
Long element start tags (consisting of the element name, attribute names and attribute values) may trigger this quota. This quota may be increased by changing the MaxBytesPerRead property on the XmlDictionaryReaderQuotas object used when creating the XML reader. Line 46, position 1235.
   at System.Xml.XmlExceptionHelper.ThrowXmlException(XmlDictionaryReader reader, String res, String arg1, String arg2, String arg3)

Is there a max read operation?
Any ideas?

Thanks

Jul 19, 2010 at 4:49 PM

Is this with the beta or the existing released component?

Jul 19, 2010 at 5:53 PM

This was addressed in the beta, grab it and give it  whirl.