O'Reilly logo

Applied Architecture Patterns on the Microsoft Platform by Stephen W. Thomas, Rama Ramani, Richard Seroter, Mike Sexton, Ewan Fairweather

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

Example solution

We can take a look at an example of this technology in action, through a demo application that has some real-world implications beyond "Hello World!". There are numerous RSS feeds available, which expose a wealth of data. In this case, we have chosen a sample feed from Microsoft because it allows us to demonstrate some versatility of SSIS, as well as how data from varying sources can be distributed throughout an enterprise. We take this feed, shred the XML, and write the resulting data to SQL Server. We will then use the Sync Framework to distribute the resulting data.

These feeds also allow us to demonstrate some of the best practices that you should implement with SSIS. They include the following:

  • Using the configuration collection ...

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