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