title: Webservice cannot retrieve data
body: <p>I am using SSIS to retrieve data from another SQL Server (not in same network)</p>
  
  <p>Sometimes the job errors but usually it works OK.</p>
  
  <p>Here's the notification I got from last time error.</p>
  
  <blockquote>
    <p>Web Service For Ms SQL:Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The Web Service threw an error during method execution. The error is: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.</p>
  </blockquote>
  
  <p>This is the html</p>
  
  <pre><code>&lt;!DOCTYPE html&gt;
  &lt;html&gt;
      &lt;head&gt;
          &lt;title&gt;Runtime Error&lt;/title&gt;
          &lt;meta name="viewport" content="width=device-width" /&gt;
          &lt;style&gt;
           body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;} 
           p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
           b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
           H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
           H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
           pre {font-family:"Consolas","Lucida Console",Monospace;font-size:11pt;margin:0;padding:0.5em;line-height:14pt}
           .marker {font-weight: bold; color: black;text-decoration: none;}
           .version {color: gray;}
           .error {margin-bottom: 10px;}
           .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
           @media screen and (max-width: 639px) {
            pre { width: 440px; overflow: auto; white-space: pre-wrap; word-wrap: break-word; }
           }
           @media screen and (max-width: 479px) {
            pre { width: 280px; }
           }
          &lt;/style&gt;
      &lt;/head&gt;
  
      &lt;body bgcolor="white"&gt;
  
              &lt;span&gt;&lt;H1&gt;Server Error in '/MYAPSSWebService' Application.&lt;hr width=100% size=1 color=silver&gt;&lt;/H1&gt;
  
              &lt;h2&gt; &lt;i&gt;Runtime Error&lt;/i&gt; &lt;/h2&gt;&lt;/span&gt;
  
              &lt;font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif "&gt;
  
              &lt;b&gt; Description: &lt;/b&gt;An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
              &lt;br&gt;&lt;br&gt;
  
              &lt;b&gt;Details:&lt;/b&gt; To enable the details of this specific error message to be viewable on remote machines, please create a &lt;customErrors&gt; tag within a "web.config" configuration file located in the root directory of the current web application. This &lt;customErrors&gt; tag should then have its "mode" attribute set to "Off".&lt;br&gt;&lt;br&gt;
  
              &lt;table width=100% bgcolor="#ffffcc"&gt;
                 &lt;tr&gt;
                    &lt;td&gt;
                        &lt;code&gt;&lt;pre&gt;
  
  &lt;!-- Web.Config Configuration File --&gt;
  
  &lt;configuration&gt;
      &lt;system.web&gt;
          &lt;customErrors mode="Off"/&gt;
      &lt;/system.web&gt;
  &lt;/configuration&gt;&lt;/pre&gt;&lt;/code&gt;
  
                    &lt;/td&gt;
                 &lt;/tr&gt;
              &lt;/table&gt;
  
              &lt;br&gt;
  
              &lt;b&gt;Notes:&lt;/b&gt; The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's &lt;customErrors&gt; configuration tag to point to a custom error page URL.&lt;br&gt;&lt;br&gt;
  
              &lt;table width=100% bgcolor="#ffffcc"&gt;
                 &lt;tr&gt;
                    &lt;td&gt;
                        &lt;code&gt;&lt;pre&gt;
  
  &lt;!-- Web.Config Configuration File --&gt;
  
  &lt;configuration&gt;
      &lt;system.web&gt;
          &lt;customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/&gt;
      &lt;/system.web&gt;
  &lt;/configuration&gt;&lt;/pre&gt;&lt;/code&gt;
  
                    &lt;/td&gt;
                 &lt;/tr&gt;
              &lt;/table&gt;
  
              &lt;br&gt;
  
      &lt;/body&gt;
  &lt;/html&gt;
  </code></pre>
  
  <p>Stack trace:</p>
  
  <blockquote>
    <p>at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection)<br>
    at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser)<br>
    at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()"</p>
  </blockquote>