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 16th, 2013, 09:42 PM
Registered User
 
Join Date: Feb 2013
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error: WSDL file is not valid in Web Service Task

Hi Travis,
I have been getting this error when executing the practice Web Service Task in Chapter 3 in this book. All the configurations are correct exactly as the book says. I did not provide a local version of the WSDL file because the HTTP Connection Mgr already points to a WSDL file on the web site. Could you tell me what I did wrong? Thanks. Emily

So here is my status: SSIS package "C:\prossis\Chapter3\WebServiceTask.dtsx" starting.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Error: 0xC002F304 at Web Service Task, Web Service Task: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.Webs erviceTaskException: The input Web Services Description Language (WSDL) file is not valid.
at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebSe rviceTaskUtil..ctor(Object connection, String downloadedWSDL)
at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebSe rviceTask.executeThread()".
Task failed: Web Service Task
Warning: 0x80019002 at WebServiceTask: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "C:\prossis\Chapter3\WebServiceTask.dtsx" finished: Failure.
 
Old March 10th, 2015, 06:44 AM
Registered User
 
Join Date: Mar 2015
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

See the other thread here:

Web Service Task in Chapter 3 not working

in short, the WDSL file from the book is out of date as the website changed.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Web Service Task in Chapter 3 not working lcsgeek BOOK: Professional Microsoft SQL Server 2012 Integration Services 2 March 8th, 2015 08:57 AM
CH8 Hyperlink Extractor Service link for wsdl Firmbyte BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 0 May 18th, 2008 05:26 AM
Error: Not able to save file using web service Pravallika BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 1 February 5th, 2007 04:43 AM
Error to Add Web Reference from a Web service jdjbarrios ASP.NET 2.0 Professional 0 July 18th, 2006 02:58 PM
WSDL Reader: Loading of the WSDL file failed. Anil .NET Web Services 0 January 23rd, 2004 02:59 PM





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