Wrox Programmer Forums
|
BOOK: Professional Microsoft SQL Server 2012 Integration Services
This is the forum to discuss the Wrox book Professional Microsoft SQL Server 2012 Integration Services by Brian Knight, Erik Veerman, Jessica M. Moss, Mike Davis, Chris Rock; ISBN: 978-1-1181-0112-4
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional Microsoft SQL Server 2012 Integration Services section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 17th, 2013, 06:45 PM
Authorized User
 
Join Date: Aug 2003
Posts: 83
Thanks: 0
Thanked 0 Times in 0 Posts
Default Web Service Task in Chapter 3 not working

I can click the Download WSDL button just fine and I recieve the Web Service Description Language file just fine. However when I click the input tab I get the following error:

TITLE: Web Service Task
------------------------------
Could not read the Web Services Description Language (WSDL) file. The input WSDL file is not valid. The following error occurred while reading the file. There is an error in XML document (3, 2)..
------------------------------

This is the content of the wsdl file that I recieved when I clicked the Download WSDL file button:

Code:
 
<html>
<script type="text/javascript">
  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-1803935-1']);
  _gaq.push(['_trackPageview']);
  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();
</script>
    <head><link rel="alternate" type="text/xml" href="/uszip.asmx?disco" />
    <style type="text/css">
 
  BODY { color: #000000; background-color: white; font-family: Verdana; margin-left: 0px; margin-top: 0px; }
  #content { margin-left: 30px; font-size: .70em; padding-bottom: 2em; }
  A:link { color: #336699; font-weight: bold; text-decoration: underline; }
  A:visited { color: #6699cc; font-weight: bold; text-decoration: underline; }
  A:active { color: #336699; font-weight: bold; text-decoration: underline; }
  A:hover { color: cc3300; font-weight: bold; text-decoration: underline; }
  P { color: #000000; margin-top: 0px; margin-bottom: 12px; font-family: Verdana; }
  pre { background-color: #e5e5cc; padding: 5px; font-family: Courier New; font-size: x-small; margin-top: -5px; border: 1px #f0f0e0 solid; }
  td { color: #000000; font-family: Verdana; font-size: .7em; }
  h2 { font-size: 1.5em; font-weight: bold; margin-top: 25px; margin-bottom: 10px; border-top: 1px solid #003366; margin-left: -15px; color: #003366; }
  h3 { font-size: 1.1em; color: #000000; margin-left: -15px; margin-top: 10px; margin-bottom: 10px; }
  ul { margin-top: 10px; margin-left: 20px; }
  ol { margin-top: 10px; margin-left: 20px; }
  li { margin-top: 10px; color: #000000; }
  font.value { color: darkblue; font: bold; }
  font.key { color: darkgreen; font: bold; }
  font.error { color: darkred; font: bold; }
  .heading1 { color: #ffffff; font-family: Tahoma; font-size: 26px; font-weight: normal; background-color: #003366; margin-top: 0px; margin-bottom: 0px; margin-left: -30px; padding-top: 10px; padding-bottom: 3px; padding-left: 15px; width: 105%; }
  .button { background-color: #dcdcdc; font-family: Verdana; font-size: 1em; border-top: #cccccc 1px solid; border-bottom: #666666 1px solid; border-left: #cccccc 1px solid; border-right: #666666 1px solid; }
  .frmheader { color: #000000; background: #dcdcdc; font-family: Verdana; font-size: .7em; font-weight: normal; border-bottom: 1px solid #dcdcdc; padding-top: 2px; padding-bottom: 2px; }
  .frmtext { font-family: Verdana; font-size: .7em; margin-top: 8px; margin-bottom: 0px; margin-left: 32px; }
  .frmInput { font-family: Verdana; font-size: 1em; }
  .intro { margin-left: -15px; }
 
    </style>
    <title>
 USZip Web Service
</title></head>
  <body>
    <div id="content">
      <p class="heading1">USZip</p><br>
 
      <span>
          <p class="intro">The following operations are supported.  For a formal definition, please review the <a href="uszip.asmx?WSDL">Service Description</a>. </p>
 
 
              <ul>
 
              <li>
                <a href="uszip.asmx?op=GetInfoByAreaCode">GetInfoByAreaCode</a>
 
                <span>
                  <br>Get State Code,City,Area Code,Time Zone,Zip Code by Area Code
                </span>
              </li>
              <p>
 
              <li>
                <a href="uszip.asmx?op=GetInfoByCity">GetInfoByCity</a>
 
                <span>
                  <br>Get State Code,City,Area Code,Time Zone,Zip Code by City
                </span>
              </li>
              <p>
 
              <li>
                <a href="uszip.asmx?op=GetInfoByState">GetInfoByState</a>
 
                <span>
                  <br>Get State Code,City,Area Code,Time Zone,Zip Code by state
                </span>
              </li>
              <p>
 
              <li>
                <a href="uszip.asmx?op=GetInfoByZIP">GetInfoByZIP</a>
 
                <span>
                  <br>Get State Code,City,Area Code,Time Zone,Zip Code by Zip Code
                </span>
              </li>
              <p>
 
              </ul>
 
      </span>
 
 
    <span>
 
    </span>
 
 
 
 
  </body>
</html>
Also downloaded the complete code from the WROX website and tried running it and received the following error:

[Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.Webs erviceTaskException: Could not read the Web Services Description Language (WSDL) file. The input WSDL file is not valid. The following error occurred while reading the file. There is an error in XML document (3, 2)..
at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebSe rviceTaskUtil..ctor(Object connection, String downloadedWSDL)
at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebSe rviceTask.executeThread()".


Any assistance would be appreciated. This is really the first data handling project of the book, I hope this isn't an indication of how the rest of the projects go.

Last edited by lcsgeek; February 17th, 2013 at 06:49 PM..
 
Old September 30th, 2013, 10:35 AM
Registered User
 
Join Date: Sep 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default c:\prossis

Looks like you are missing the file from the c:\prossis directory. I'm not seeing where these files in the c:\prossis come from. I was thinking the files would be part of the downloads.

Thanks
 
Old March 8th, 2015, 08:57 AM
Registered User
 
Join Date: Mar 2015
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

He has the file, it's just not valid as the providor has changed their definitions since publication of the book. You need to visit http://www.webservicex.net/uszip.asmx?wsdl then download that page as your new wsdl file. I just had exactly the same problem and it worked when I did this.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with web service example chapter 14 dontcallmejeff BOOK: Beginning iPad Application Development 20 December 9th, 2011 02:58 PM
Web service not working properly in IIS Abhinavnaresh ASP.NET 2.0 Professional 1 April 10th, 2008 08:53 AM
Chapter 4 Web Service christolo BOOK: Professional ASP.NET 2.0 and Special Edition; ISBN: 978-0-7645-7610-2; ISBN: 978-0-470-04178-9 0 July 11th, 2007 08:25 AM
Chapter 6 Math Web Service mmount BOOK: Professional Ajax ISBN: 978-0-471-77778-6 1 November 14th, 2006 07:55 AM
Chapter 12, C#, UpdateScore Web Service skafando BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 1 October 24th, 2006 12:02 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.