I'm using SSIS 2005 for my package.
When I launch it I have this error:
Error: System.ServiceModel.CommunicationException: The maximum message size
quota for incoming messages (1000000) has been exceeded. To increase the
quota, use the MaxReceivedMessageSize property on the appropriate binding
element. ---> System.ServiceModel.QuotaExceededException: The maximum message
size quota for incoming messages (1000000) has been exceeded. To increase the
quota, use the MaxReceivedMessageSize property on the appropriate binding
element. --- End of inner exception stack trace --- Server stack trace:
at
System.ServiceModel.Channels.HttpInput.ThrowMaxRec eivedMessageSizeExceeded()
at System.ServiceModel.Channels.HttpInput.GetMessageB uffer() at
System.ServiceModel.Channels.HttpInput.ReadBuffere dMessage(Stream
inputStream) at
System.ServiceModel.Channels.HttpInput.ParseIncomi ngMessage(Exception&
requestException) at
System.ServiceModel.Channels.HttpChannelFactory.Ht tpRequestChannel.HttpChannelRequest.WaitForReply(T imeSpan
timeout) at System.ServiceModel.Channels.RequestChannel.Reques t(Message
message, TimeSpan timeout) at
System.ServiceModel.Dispatcher.RequestChannelBinde r.Request(Message message,
TimeSpan timeout) at
System.ServiceModel.Channels.ServiceChannel.Call(S tring action, Boolean
oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs,
TimeSpan timeout) at
System.ServiceModel.Channels.ServiceChannel.Call(S tring action, Boolean
oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs) at
System.ServiceModel.Channels.ServiceChannelProxy.I nvokeService(IMethodCallMessage
methodCall, ProxyOperationRuntime operation) at
System.ServiceModel.Channels.ServiceChannelProxy.I nvoke(IMessage message)
Exception rethrown at [0]: at
System.Runtime.Remoting.Proxies.RealProxy.HandleRe turnMessage(IMessage
reqMsg, IMessage retMsg) at
System.Runtime.Remoting.Proxies.RealProxy.PrivateI nvoke(MessageData& msgData,
Int32 type) at
Microsoft.Samples.SqlServer.SSIS.SharePointUtility .ListsService.ListsSoap.GetListItems(GetListItemsR equest
request) at
Microsoft.Samples.SqlServer.SSIS.SharePointUtility .ListsService.ListsSoapClient.ListsService_ListsSo ap_GetListItems(GetListItemsRequest
request) at
Microsoft.Samples.SqlServer.SSIS.SharePointUtility .ListsService.ListsSoapClient.GetListItems(String
listName, String viewName, XElement query, XElement viewFields, String
rowLimit, XElement queryOptions, String webID) at
Microsoft.Samples.SqlServer.SSIS.SharePointUtility .Adapter.ListsAdapter.GetSharePointListItems(Strin g
listName, String viewId, XElement queryXml, XElement viewXml, Int16
pagingSize, XElement queryOptionsXml) at
Microsoft.Samples.SqlServer.SSIS.SharePointUtility .Adapter.ListsAdapter.GetSharePointListItemData(St ring
listName, String viewId, IEnumerable`1 fieldNames, XElement query, Boolean
isRecursive, Int16 pagingSize) at
Microsoft.Samples.SqlServer.SSIS.SharePointUtility .ListServiceUtility.GetListItemData(Uri
sharepointUri, String listName, String viewName, IEnumerable`1 fieldNames,
XElement query, Boolean isRecursive, Int16 pagingSize) at
Microsoft.Samples.SqlServer.SSIS.SharePointListAda pters.SharePointListSource.PrimeOutput(Int32
outputs, Int32[] outputIDs, PipelineBuffer[] buffers) at
Microsoft.SqlServer.Dts.Pipeline.ManagedComponentH ost.HostPrimeOutput(IDTSManagedComponentWrapper90
wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer90[] buffers, IntPtr
ppBufferWirePacket)

How can I solve this issue? Many thanks.

By looking at the exception, it looks like your package calls a sharepoint
utility and you can change the value for
MaxReceivedMessageSize property in your SahrePointUtility project's
configuration file.

Hope it helps!!

"Pasquale" wrote: