Home > SSIS > Call a web service method using SSIS

Call a web service method using SSIS


Web Services

Web services are web application components which are communicating using open protocols (SOAP (Simple Object Access Protocol)). XML is the basis for Web services that can be used by other applications. Web Services are used to reuse application-components or Connect existing software.

Calling a Web Services method using Web Service Task

Web Service Task

The Web Service task executes a Web service method and writes the result to a variable or file. These methods usually carry an input and return the result. We can have methods without parameters.

We need to have HTTP connection manage in the package to map the Web Services.

Web Service Description Language (WSDL) file can be download manually or by web service task automatically to local machine.

Scenario

I have a web service that will give me the forecast value based on the ZIP code as an input parameter to the method.

So, I am using a SSIS package to execution the method and get the result in a file.

In this exercise, I will be using a free web service component from this website.

Before begin, I have manually downloaded the WSDL  file from the site and stored it in my local machine. If it opens as a web page then save the page to a file.

Implementation

Step 1: Create a new package and add Web Service Task in to the package

Step 2: Edit the Task.

Step 3: Create HTTP connection.

Step 4: Fill the http web address in the Server URL property and Test the connection. Click OK

Step 5: Locate the WSDL file in the local machine in WSDL file property.

Step 6: Go to Input tab and select the Service and Method property. Give a static value in the value column. Note: we can use variable to assign dynamic value to zip code field.

Step 7: Go to Output tab and provide the output file path in the file property.

Step 8: Click OK and execute the package.

Output file

Thanks for reading. Rate this article.

Subscribe with your E-Mail to see the latest posts in your inbox as soon as it has got published in this site.

 

Advertisements
Categories: SSIS Tags: ,
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: