Error Updating NTEXT Column in SharePoint List Using SP List Destination
I am getting an error when I try to update (or insert) data into a SharePoint List Multi-Row field. The field's property is set to NTEXT. I have tried changing the datatype of the data being written to that field from WSTR to NTEXT and everything in between,
but it always throws an error. If I omit sending data to those columns, my task runs fine.
[SharePoint List Destination [653]] Error: System.ServiceModel.ProtocolException: The remote server returned an unexpected response: (400) Bad Request. ---> System.Net.WebException: The remote server returned an error: (400) Bad Request. at System.Net.HttpWebRequest.GetResponse()
at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout) --- End of inner exception stack trace --- Server stack trace: at System.ServiceModel.Channels.HttpChannelUtilities.ValidateRequestReplyResponse(HttpWebRequest
request, HttpWebResponse response, HttpChannelFactory factory, WebException responseException, ChannelBinding channelBinding) 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.UpdateListItems(UpdateListItemsRequest request) at Microsoft.Samples.SqlServer.SSIS.SharePointUtility.ListsService.ListsSoapClient.ListsService_ListsSoap_UpdateListItems(UpdateListItemsRequest
request) at Microsoft.Samples.SqlServer.SSIS.SharePointUtility.ListsService.ListsSoapClient.UpdateListItems(String listName, XElement updates) at Microsoft.Samples.SqlServer.SSIS.SharePointUtility.Adapter.ListsAdapter.ExecuteSharePointUpdateBatch(String listName,
String viewId, XElement batchXml, Int16 batchSize) at Microsoft.Samples.SqlServer.SSIS.SharePointUtility.ListServiceUtility.UpdateListItems(Uri sharepointUri, NetworkCredential credentials, String listName, String viewName, IEnumerable`1 fieldValueList, Int16
batchSize) at Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.SharePointListDestination.ProcessInput(Int32 inputID, PipelineBuffer buffer) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper100 wrapper,
Int32 inputID, IDTSBuffer100 pDTSBuffer, IntPtr bufferWirePacket)
How do you update SharePoint Lists NTEXT Columns using SSIS?
Thanks,
Lee
July 31st, 2012 3:05pm
Sharepoint List destination is a third party component, it is always better to ask questions about this kind of components in their own website:
http://sqlsrvintegrationsrv.codeplex.com/discussions
on the other hand I found this which might be useful:
http://sqlsrvintegrationsrv.codeplex.com/discussions/291075http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
July 31st, 2012 4:31pm
Lee,
I trust Reza's reply is the answer, agree?Arthur My Blog
August 14th, 2012 7:34pm
Only to post to the other board. I snot have a solution.
Free Windows Admin Tool Kit Click here and download it now
August 28th, 2012 4:43pm
So then i understand the other forum did not provide a solution.
Would you like me to move this thread to the SharePoint forum section in hope it will be acted upon better?Arthur My Blog
August 28th, 2012 4:49pm
Yes, please move it over.
Thanks,
Lee
Free Windows Admin Tool Kit Click here and download it now
August 28th, 2012 5:01pm