1

Closed

Error using SharePoint List Source

description

As list source properties I have specified the SiteURL as http://sitename/lists/contacts/allitems.aspx, the SiteListName as Contacts and nothing for CamlQuery and I have tried to open the advanced error for the data flow with this error message:
error in data flow task [SharePoint List Source [24]]: System.ServiceModel.ProtocolException: the content type text/html; charset=utf-8 of the reply message does not corresponding to binding content type (text/html; charset=utf-8) ...
I have SQL Server 2008 RC0 on my machine. I'm pointing to a server with MOSS 2007.
Closed Sep 9, 2008 at 10:55 PM by kevinidzi
Issue with CAML query sent to the component.

comments

kevinidzi wrote Sep 2, 2008 at 4:37 PM

Site URL: http://sitename
Sitelistname as "Contacts"

pscorca wrote Sep 3, 2008 at 10:09 AM

I have specified only http://sitename as Site URL. The error is changed:
Microsoft.Samples.SqlServer.SSIS.SharePointUtility.SharePointUnhandledException: Unhandled SharePoint
Exception ---> System.ServiceModel.FaultException: exception type generated 'Microsoft.SharePoint.SoapServer.SoapServerException'.
Could depends on the CAML query?

kevinidzi wrote Sep 3, 2008 at 4:57 PM

Have you tried without the CAML query? If it works without the modified CAML query and is now erroring, then I would say it is probably the query. There are numerous CAML Query editors on the web, they are really great and are helpful to getting it just right.

pscorca wrote Sep 3, 2008 at 5:02 PM

I have solved: I put the correct value for the Sitelistname and I have let the default value for the CAML query.
Is it possible to create a similar component for SQL Server 2005? Thanks

kevinidzi wrote Sep 9, 2008 at 10:55 PM

I'm going to mark this issue as closed, since you found the issue was in your CAML query. If you want to put up a feature request for a sql 2005 compiled component, then add a new issue which people can vote up.