O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required