Share Point List Source error in SSIS

Oct 3, 2014 at 7:58 PM
I have seen this mentioned here before and in other sources but I have yet to see a solution. From what I gather it is an invalid URL but that does not seem possible. I have a Sharepoint list that I pull data from in SharePoint 2007 using SharePoint List Source in SSIS without issue. We are upgrading SharePoint to 2010 and now I am getting an error trying to pull data from the new list.

Error at Data Flow Task [SharePoint List Source 1 [256]]: System.ServiceModel.ProtocolException: The content type text/html; charset=utf-8 of the response message does not match the content type of the binding (text/xml; charset=utf-8). If using a custom encoder, be sure that the IsContentTypeSupported method is implemented properly. The first 1024 bytes of the response were: '<html>
<head>
<title>BIG-IP logout page</title>
<link rel="stylesheet" type="text/css" HREF="/public/include/css/apm.css">
<script src="/public/include/js/common.js" language="javascript"></script>
<script src="/public/include/js/u_plugin.js" language="javascript"></script>

<script language="javascript">
  function InsertActivexControl(clsid, params)
  {
      var container = document.getElementById("logoutActivexContainer");

      if (navigator.appName == "Microsoft Internet Explorer") {
          var paramsCode = "";
          for (var item in params) {
              paramsCode += "<param name='" + item + "' value='" + params[item] + "'>";
          }

          container.innerHTML = 
              "<center><object classId=CLSID:" + clsid + " border=0 width=1 height=1>" +
              paramsCode + "</object></center>";
      }
      else {
          var pluginHost = new UPluginHost("", container);

Any insite would be appriciated.
Oct 3, 2014 at 8:01 PM