SSIS: Web Service Task

Have you looked into this task. Pretty Cool !!!.

Under the general tab:

1.     Create HTTP connection pointing to free service (at the time of the writing and please try at your own risk) lets say http://www.webservicex.net/uszip.asmx?wsdl
2. Test Connection to make sure you connect.
3. You could download wsdl file to your local computer by setting wsdl file property as c:\GetInfoByZIP.wsdl

Under the input tab

1. Choose service as USZip
2. Method as GetInfoByZip
3. Under the service section, you could hard code uszip as 92660 (for newport beach)

Under the output tab

1. Choose output type as FileConnection
2. File as c:\myfilename.xml

Now execute the Web service task and check out the newly created xml file under c:\. It stores following information in the xml file which is truly awesome

- <NewDataSet xmlns="">
- <Table>
  <CITY>Newport Beach</CITY>
  <STATE>CA</STATE>
  <ZIP>92660</ZIP>
  <AREA_CODE>949</AREA_CODE>
  <TIME_ZONE>P</TIME_ZONE>
  </Table>
  </NewDataSet>

Try it out and applications are limited by your own imagination.

HTH..

ZULFIQAR SYED

Comments

[tharpa]

Great article. It's always rare to find something that walks you through a task, step by step.

[Cristiano]

Thanks for article.
Do you have idea how i can do the same job with an output variable?

thanks