Microsoft SQL Server 2005 Integration Services

Book description

All medium to large companies have to deal with data being stored in a number of databases, spreadsheets and proprietary applications. Bringing all this data together into one system can be useful to analyzing the business; but can also be quite difficult to do. Integration Services is the next big bet in Microsoft's business intelligence lineup, providing you with true enterprise extract transform and load features (ETL).

Microsoft SQL Server 2005 Integration Services concentrates on providing you with real world solutions to real world problems, giving you a head start on various projects. If you are only evaluating Integration Services, you'll be able to focus on the early chapters with the option of drilling down into details in the later chapters where some of the more complex concepts will be discussed in detail. The interesting sidebars peppered throughout the book provide insight into the processes, people and decisions that yielded the final IS product.

Table of contents

  1. Title Page
  2. Copyright Page
  3. Contents at a Glance
  4. Table of Contents
  5. Foreword
  6. About the Author
  7. Acknowledgments
  8. We Want to Hear from You!
  9. PART I. Getting Started
    1. Chapter 1. Welcome to SQL Server Integration Services 2005
    2. Chapter 2. Setting Up Integration Services
    3. Chapter 3. Migrating from DTS
    4. Chapter 4. Building a Package—Quick Start
  10. PART II. Integration Services Basics and Concepts
    1. Chapter 5. The Business Intelligence Development Studio
    2. Chapter 6. The Building Blocks of Integration Services
    3. Chapter 7. Grouping Control Flow with Containers
  11. PART III. Control Flow Services
    1. Chapter 8. The Stock Tasks
    2. Chapter 9. Using Expressions
    3. Chapter 10. The Stock Connection Managers
    4. Chapter 11. Logging and the Stock Log Providers
    5. Chapter 12. The Venerable Variable
    6. Chapter 13. Looping and Foreach Enumerators
  12. PART IV. Management Services
    1. Chapter 14. Configuring and Deploying Solutions
    2. Chapter 15. Using The Script Task
    3. Chapter 16. Using Source Control
    4. Chapter 17. SQL Server Management Studio
    5. Chapter 18. Securing Packages
  13. PART V. The Data Flow Task
    1. Chapter 19. Introducing the Data Flow Task
    2. Chapter 20. The Stock Data Flow Components
    3. Chapter 21. Using the Script Component
    4. Chapter 22. Advanced Data Flow Transformations
    5. Chapter 23. Data Flow Task Internals and Tuning
  14. PART VI. Programming Integration Services
    1. Chapter 24. Building Custom Tasks
    2. Chapter 25. Building Custom Data Flow Components
  15. Appendix A. Error, Warning, and Information Events
  16. Appendix B. Expression Evaluator Reference Sheet
  17. Index

Product information

  • Title: Microsoft SQL Server 2005 Integration Services
  • Author(s):
  • Release date: July 2006
  • Publisher(s): Sams
  • ISBN: 0672327813