O'Reilly logo

Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services by Régis Baccaro, Joost van Rossum

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

CHAPTER 15

image

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 ...

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