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): 35093/ 420

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

Article Feedback

Title:  
Name:  
Url: ( Optional )
Comment:  
Please add 3 and 8 and type the answer here:

User Comments

Title: Customers info return   
Name: Wilfredo Sanchez
Date: 2/1/2010 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: 1/20/2010 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: 12/24/2009 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-2010 ASPAlliance.com  |  Page Processed at 3/21/2010 12:42:14 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search