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