Summary

Microsoft has made it easy to work with data from heterogeneous sources since DTS was first released. The addition of the XML data source and Web Service task in SSIS enhances this tremendously. In a perfect world, maybe all data would live in SQL Server. Until then, use SSIS to access data outside of SQL Server and even outside your Enterprise.

So far this book has covered the basic techniques of building SSIS packages. You now have enough knowledge to put all the pieces together and build a more complex package. The next chapter focuses on how to guarantee that your SSIS packages will scale and work reliably.