O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Reading data from web methods: Web Service Task

Web services are in wide use nowadays as a method to interact between systems in a cross-platform environment. As web services work with XML and serialize their outputs in the XML format and also get their inputs in the XML format, they are widely used as a standard way to interconnect systems together. There are lots of benefits of using web services, but discussing all of them is beyond the scope of our book.

This recipe demonstrates the use of the Web Service Task using a free web service chosen from among several alternatives on the Internet. This web service is very simple and returns the cities from a specific country:

How to do it...

Consider a scenario where SSIS periodically needs to get data ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required