Chapter 16. Advanced Features in Microsoft SQL Server 2008 Integration Services
In Chapter 15, we looked at the mechanics of working with some of the major components that make up the Microsoft SQL Server 2008 Integration Services (SSIS) platform. We covered the development of packages with Business Intelligence Development Studio (BIDS), control flow, data flow, variables, expressions, and connection managers. In this chapter, we work with some of the more advanced features available when developing Integration Services packages, including error and event handling, logging, debugging, and checkpoints and transactions. We also recommend some best practices you should follow when designing Integration Services packages. Finally, we introduce data ...
Get Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 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.
