Chapter 7 explained how to use a web service in a Script Task, but it is also useful in the Data Flow Task for enriching your data, as a destination, and even as a source. Many products use web services as an interface. Tools like Microsoft Dynamics CRM and SharePoint store all data in an SQL Server database, but you are not allowed to edit the data directly in the database. Instead, the vendors provide web services to modify data. This chapter provides some web service examples for commonly used Microsoft products and for web services that you can find on the Internet.
Enriching with Weather
This first example uses the ...