Microsoft® SQL Server® 2008 Integration Services: Problem-Design-Solution

Introduction

Our world is a world full of data and, as developers, database administrators (DBAs), or data architects, your job will no doubt require processing data — consolidating data, integrating system data, migrating data, cleansing data, transforming data, or loading data into a data warehouse. This book is about solving problems and building solutions with SQL Server 2008 Integration Services (SSIS). It focuses on the design best practices for the top uses and challenge of SSIS.

In this book, you will learn about how to approach the following kinds of projects, and how to effectively work within SSIS to apply its functionality to these common project requirements and challenges:

• Designing Extraction Transformation and Loading (ETL) solutions with SSIS to handle file management, data warehouse processing, systems integration, and data cleansing.
• Resolving common SSIS package deployment and auditing challenges that often get in the way of designing a solid solution.
• Building an SSIS-based solution that performs well, and can deal with failures or unplanned system outages

As an author team, our vision for this book is very different than the other books on the shelves, which focus mainly on how to use the knobs and buttons in SSIS. Books such as the Professional Microsoft SQL Server 2008 Integration Services (Indianapolis: Wiley, 2008) are very valuable to have on your bookshelf for reference and for learning SSIS. But this book is about going to the next level of solution ...