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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.