In this chapter, you’ve learned a lot about Integration Services, from fundamental concepts to designing and managing packages. Far from being a complete reference for Integration Services, this chapter introduced you to the most important things you need to know to start building basic packages and to put packages into production. Some advanced features were also briefly discussed so you can consider their usefulness for more complex data integration projects you tackle once you gain more experience. As data continues to proliferate in organizations, there will be plenty of opportunities to expand your data integration skills and take full advantage of the flexibility that Integration Services offers.

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.