Sharepoint list source issues

Oct 12, 2011 at 1:53 PM


When trying to connect to a SharePoint List Source i get the below error:

The component has detected potential metadata corruption during validation.

Error at Data Flow Task [SharePoint List Source [1]]: System.ServiceModel.ProtocolException: The remote server returned an unexpected response: (417) Expectation failed. ---> System.Net.WebException: The remote server returned an error: (417) Expectation failed.

   at System.Net.HttpWebRequest.GetResponse()

   at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)

   --- End of inner exception stack trace ---

Can anyone advise what the issue may be?

Thanks in advance

Oct 12, 2011 at 4:27 PM

That is a web error from your SharePoint.  Are you able to hit the list yourself and browse around?

Oct 13, 2011 at 10:23 AM

 I found out that there was squid proxy settings in IE.  As soon as i removed these the package works.


Oct 14, 2011 at 8:15 AM

Great, I added that to the main Faq in the Documentation section.