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

[PetMet]

Thank you. I agree with the other posters, it's very nice to walk through a basic tutorial and see something actually work, especially after I've been pounding on new ETL I'm writing that doesn't work. Yours did.

[RamonGustav]

Are you eager to secure funds for that dream project of yours?

[Music_master]

I think you are not quite right and you should still studying the matter.

[Antivirus_man]

You write well will be waiting for your new publications.

[school_dubl]

Hi Merry Christmas and Happy New Year

[motion sensors]

The siren is simply a loud noise that emits when the home security alarm system is breached.