A Step-by-Step Approach to Creating a Web Service Task Using SQL Server Integration Services: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
A Step-by-Step Approach to Creating a Web Service Task Using SQL Server Integration Services

page 2 of 4

by Jayaram Krishnaswamy
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 40771/ 30

Article Contents:

Web Service used in this tutorial

Simply stated, the web service accepts text in the ASCII format and converts it to Base64 format. For example, it takes the connection string for a database connection shown in Figure 1 and converts it into a machine readable Base64 format shown in Figure 2. While Figure 1 is easy to read, Figure 2 is not.

Figure 1

Figure 2

Details of how this web service is created have been described in an earlier tutorial while only a few screen shots of its description are shown here. The web service is created using the Visual Studio 2005 IDE along the lines fully documented in the above article.

« (Page 1)

View Entire Article

(Page 3) »

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