A Step-by-Step Approach to Creating a Web Service Task Using SQL Server Integration Services
page 1 of 4
Published: 26 Feb 2007
Abstract
Web Services and SOA are assuming greater importance in the IT strategy of businesses. This tutorial describes a step-by-step method to create a SSIS package containing a web service task. The web service used in the tutorial will be discussed first. This will be followed by describing how the package is configured using the Visual Studio 2005 IDE.
by Jayaram Krishnaswamy
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 83985/ 133

Introduction

IT strategy of businesses is moving towards leveraging Web Services and SOA. Service Oriented Architecture utilizes web services and defines how to integrate and implement services that deliver usable services in a distributed environment transparent to the end user. In the initial phase, web services were based on client/server type of interaction exposing specific methods (currency conversion, units of measurement conversion, verifying address, etc) to the end user across the internet. This is changing into a more distributed architecture involving intermediaries as well.

With the introduction of SQL Server Integration Services beginning with SQL Server 2005, Microsoft introduced the Web Service Task into its integration toolset. With this task it is possible to create a SSIS package to expose the web service. This tutorial describes a step-by-step method to create a SSIS package containing a web service task. The web service used in the tutorial will be discussed first. This will be followed by describing how the package is configured using the Visual Studio 2005 IDE. The Visual Studio 2005, The SQL Server Express (not used in this tutorial), and the Information Services 5.1 are all installed on the same machine with the Windows XP Media Center Edition Operating System.


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-2017 ASPAlliance.com  |  Page Processed at 2017-02-23 1:31:41 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search