Mastering SQL Server 2017
by Milos Radivojevic, Dejan Sarka, William Durkin, Christian Cote, Matija Lah
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access