Exception during a SSIS 2005 package execution

xyz_jat

2009-01-30 17:14:07 UTC

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!!

Post by Pasquale
I'm using SSIS 2005 for my package.
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
at
System.ServiceModel.Channels.HttpInput.ThrowMaxReceivedMessageSizeExceeded()
at System.ServiceModel.Channels.HttpInput.GetMessageBuffer() at
System.ServiceModel.Channels.HttpInput.ReadBufferedMessage(Stream
inputStream) at
System.ServiceModel.Channels.HttpInput.ParseIncomingMessage(Exception&
requestException) at
System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan
timeout) at System.ServiceModel.Channels.RequestChannel.Request(Message
message, TimeSpan timeout) at
System.ServiceModel.Dispatcher.RequestChannelBinder.Request(Message message,
TimeSpan timeout) at
System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean
oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs,
TimeSpan timeout) at
System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean
oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs) at
System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage
methodCall, ProxyOperationRuntime operation) at
System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)
Exception rethrown at [0]: at
System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage
reqMsg, IMessage retMsg) at
System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData,
Int32 type) at
Microsoft.Samples.SqlServer.SSIS.SharePointUtility.ListsService.ListsSoap.GetListItems(GetListItemsRequest
request) at
Microsoft.Samples.SqlServer.SSIS.SharePointUtility.ListsService.ListsSoapClient.ListsService_ListsSoap_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(String
listName, String viewId, XElement queryXml, XElement viewXml, Int16
pagingSize, XElement queryOptionsXml) at
Microsoft.Samples.SqlServer.SSIS.SharePointUtility.Adapter.ListsAdapter.GetSharePointListItemData(String
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.SharePointListAdapters.SharePointListSource.PrimeOutput(Int32
outputs, Int32[] outputIDs, PipelineBuffer[] buffers) at
Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper90
wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer90[] buffers, IntPtr
ppBufferWirePacket)
How can I solve this issue? Many thanks.