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 of SSIS to store key metadata (for example, the path to the RSS feed)

• Some logging and error-handling best practices

We should note a few things. SSIS defaults to the .NET framework version 2.0, which contained some powerful tools for handling...