CHAPTER 15
Web Services
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 ...
Get Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.