A Step-by-Step Approach to Creating a Web Service Task Using SQL Server Integration Services
page 4 of 4
by Jayaram Krishnaswamy
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 39842/ 113

Summary

The Web Service task can be created quite easily provided the proper definition of the service, its methods, the input/output variables associated with the methods and the related WSDL file location are available. While the web URL reference of the WSDL is easily created in the VS Studio 2005, the WSDLFile creation in the Web Service Task Editor was not straight forward using the available tools on this wizard (Download WSDL in Figure 16). However, creating a web service consuming client would easily produce a WSDL file that can be persisted to the hard drive which is accepted by the Web Service Task Editor interface. The creation of the consuming client was not described in this tutorial, but numerous examples are available at the suggested resource. The client project folder is available on request by sending an e-mail to the author.


View Entire Article

User Comments

Title: Web Development Services   
Name: Jayaram Krishnaswamy
Date: 2012-10-30 9:43:30 AM
Comment:
I am not sure if you have taken a look at my book on integration services. You may find similar articles in my blogs,
http://hodentek.blogspot.com

and

http://hodentekMSSS.blogspot.com
Title: Web Development Services   
Name: Suman
Date: 2012-10-30 7:20:13 AM
Comment:
Through the another blog , I came to know about SSIS services. I tried to apply but it shows some error. I will figure out all the above points and wish to resolve the problem soon.
Title: web services task   
Name: bhanu
Date: 2010-06-15 10:00:15 AM
Comment:
It was nice explanation for the web services task in ssis.
Rhanks alot for you help and please keep up the good work.
Title: Customers info return   
Name: Wilfredo Sanchez
Date: 2010-02-01 12:35:29 PM
Comment:
Hi there,
I'm trying to store in a table the data returned from a web service. The input variables are the ID type and the ID. Can you tell me what objects must I use to do this process?
How would you do?
Let me know if you help me...

Thanks
Title: Programmer   
Name: GB
Date: 2010-01-20 1:09:50 PM
Comment:
This was perfect. Thanks
Title: A Step-by-Step Approach to Creating a Web Service Task Using SQL Server Integration Services   
Name: Jayaram Krishnaswamy
Date: 2009-12-24 5:41:40 PM
Comment:
This article leaves off where I need to start up - how to use variables in BIDS to represent inputs to the web service. Not just primitive types like int and string - those work fine - but complex types, arrays or even a simple collection.

Product Spotlight
Product Spotlight 





Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-10-04 5:27:52 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search