O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

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

How it works...

The Airport Info by Country source component connects to a publicly available web service that provides information about airports in various countries. It retrieves the list of airports for the country specified by the CountryName package parameter.

Alternatively, the country name could also be supplied via a variable populated in a Foreach Loop container, so that the same data flow is executed multiple times for multiple countries.

After the data is retrieved from the web service, it is placed into a variable. When the component starts to generate rows, specific properties of each item retrieved from the web service are placed into the downstream pipeline. Each row in the components output represents one entity retrieved ...

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