Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2014 > BOOK: Professional Microsoft SQL Server 2014 Integration Services
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Professional Microsoft SQL Server 2014 Integration Services
This is the forum to discuss the Wrox book Professional Microsoft SQL Server 2014 Integration Services by Brian Knight, Devin Knight, Jessica M. Moss, Mike Davis, Chris Rock; ISBN: 978-1-118-85087-9
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional Microsoft SQL Server 2014 Integration Services section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old June 26th, 2016, 11:09 PM
Registered User
Points: 10, Level: 1
Points: 10, Level: 1 Points: 10, Level: 1 Points: 10, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2016
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default p. 59-60 Web Service Task - Cannot select web service method

On p. 59, step #2 instructs you to follow the example given on p. 56-59 for accessing US Zip code services through webservicex.net/uszip.asmx.

I was able to get part way through the instructions. I thought I did "The General Tab" on p,. 57 successfully. I then want to start on "The Input Tab" by clicking it, but it gives me an error:
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)..
I found the text for The General Tab confusing. It says "The property is required only if you don't provide the WSDL parameter in the Connection Manager." However, I don't see where to do that in the Connection Manager.

This lead me to conclude that I needed to give a file name and use the "Download WDSL" button. I did that.

The file it downloaded does not look like a WDSL file to me, but a HTML file. This looks to be the cause of the error message, but I don't understand why the WDSL button didn't fetch WDSL.

Have I done something wrong?

[By the way, I think that paragraph needs some work. It seems contradictory in regards what the presence of the parameter file means.]

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; }
		
		font.value { color: darkblue; font: bold; }
		font.key { color: darkgreen; font: bold; }
		font.error { color: darkred; font: bold; }
		
		.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; }
		
           
    </style>
 <link href="https://maxcdn.bootstrapcdn.com/bootswatch/3.3.5/journal/bootstrap.min.css" rel="stylesheet" integrity="sha256-bPSyJP9+ovy9/YbIwvZyX6r2M4PkiF01vt0zuDLUEzs= sha512-F4ep7hh9V7i7UvRF56Vq8VgjFIFGRVaE2y5UZ2FtIcMWoLFiDxTmHgnDm1XDZGcc6Vtp+kwtL0Kd3VA8uBMK9g==" crossorigin="anonymous" />


    <style type="text/css">
    
.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">

      

      

      <span>

          
          
              <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>
    
      

      

      <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>
  </body>
</html>
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Error: WSDL file is not valid in Web Service Task newstudent BOOK: Professional Microsoft SQL Server 2012 Integration Services 1 March 10th, 2015 06:44 AM
Web Service Task in Chapter 3 not working lcsgeek BOOK: Professional Microsoft SQL Server 2012 Integration Services 2 March 8th, 2015 08:57 AM
Web service task example - chapter 13 RikMargo BOOK: Professional Microsoft SQL Server 2012 Integration Services 0 June 25th, 2014 07:50 AM
About method of class in Web Service hueduongit .NET Web Services 5 December 11th, 2003 08:09 PM
Object as parameter in a web service method evandro.paula .NET Web Services 3 October 14th, 2003 02:20 PM



All times are GMT -4. The time now is 12:41 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.