Chapter 24. SQL Server Integration Services

After completing this chapter, you will be able to

  • Create an SSIS project

  • Build a package

  • Implement tasks and transforms

  • Perform exception handling

  • Manage package configurations

  • Deploy a package

The first 23 chapters have provided an overview of the features available within the relational engine. By itself, the relational engine represents a flexible, feature-rich platform for developing business applications. What sets SQL Server apart from every other Database Engine is the inclusion of three additional, enterprise-class products collectively referred to as the business intelligence stack. SQL Server Integration Services (SSIS) is designed to provide the infrastructure components that allow data to be moved ...

Get Microsoft® SQL Server® 2008 Step by Step 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.