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

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.

View Entire Article

User Comments

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


Title: Web Development Services   
Name: Suman
Date: 2012-10-30 7:20:13 AM
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
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
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...

Title: Programmer   
Name: GB
Date: 2010-01-20 1:09:50 PM
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
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-2023 ASPAlliance.com  |  Page Processed at 2023-09-29 9:58:50 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search