How This Book Is Organized
This book is organized into eight parts starting with basic introductory or conceptual discussions and steadily transitioning to more advanced topics. The first parts are appropriate for those seeking a high-level overview of Integration Services. The middle parts are appropriate for users such as database administrators, ETL developers, and data architects. The last part is appropriate for those interested in writing custom components or simply better understanding how Integration Services works “under the covers.”
- Part I, “Getting Started,” covers how to set up the sample packages and sources, set up Integration Services, and migrate packages from DTS.
- Part II, “Integration Services Basics,” is a conceptual and practical guide to understanding and using the product. This is a high-level overview of important concepts.
- Part III, “Control Flow Services,” covers the actual process of building packages and should give those who are new to SSIS the basic skills necessary to find their way around in the designer.
- Part IV, “Management Services,” covers some of the more challenging topics such as how to debug, troubleshoot, diagnose, secure, and deploy packages.
- Part V, “The Data Flow Task,” covers the stock tasks and other control flow features of Integration Services.
- Part VI, “Solving Common Challenges,” covers the features that support the day-to-day management of Integration Services solutions.
- Part VII, “Advanced Package Concepts and Patterns,” focuses on exploring the capabilities of the Data Flow Task and components.
- Part VIII, “Programming Integration Services,” teaches you how to build components that plug into Integration Services. These look good now.
Each chapter was written to stand alone as much as possible. Although some topics naturally rely on other previously discussed concepts, great effort was made to write the chapters so that each could be read independently. Also, most of the topics are reinforced with samples. Samples are an important part of this book and should be studied carefully if you want to fully understand Integration Services.