Expert SQL Server™ 2005 Integration Services

Expert SQL Server™ 2005 Integration Services

by Brian Knight, Erik Veerman
Released May 2007
Publisher(s): Wrox
ISBN: 9780470134115

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

As a practical guide for Integration Services ETL development, this book shows you ways to implement your ETL solution requirements from the data to the administration and everything in-between. Each chapter begins with a review of pertinent ETL concepts and moves into working those out into a design with multiple examples and related Integration Services features with the end goal of putting it all together to get a solution.

Table of contents

  1. Copyright
  2. About the Authors
  3. Contributing Author
  4. Dedication
  5. Credits
  6. Acknowledgments
  7. Introduction
  8. Getting Started
    1. Choosing the Right Tool for the Job
    2. SSIS Review
    3. Summary
  9. Extending Scripts in SSIS
    1. Script Tasks and Custom Libraries
    2. Building a Custom Assembly
    3. Making Connections Configurable and Dynamic
    4. Raising Error Events
    5. Encrypting Data Through Script Components
    6. Data Profiling
    7. Summary
  10. Data Extraction
    1. Package Connections and Data Flow Sources
    2. Incremental Data Extraction
    3. Tracking Data Lineage Identifiers
    4. Summary
  11. Dimension ETL with SSIS
    1. Dimension ETL Overview
    2. Dimensions: The Basics
    3. Dimension ETL: The Challenge
    4. SSIS Slowly Changing Dimension Wizard
    5. Creating a Custom Slowly Changing Package
    6. Summary
  12. Fact Table ETL
    1. Fact Table Overview
    2. Fact Table ETL
    3. Fact Table ETL Challenge
    4. Fact Table ETL Basics
    5. Advanced Fact Table ETL Concepts
    6. Summary
  13. Processing Analysis Services Objects with SSIS
    1. SSAS ETL Processing and Management Overview
    2. SSAS Integration Basics Within SSIS
    3. Advanced Processing and Partition Management Examples
    4. Summary
  14. Package Reliability
    1. Error and Event Handling
    2. Logging
    3. Checkpoint Files
    4. Transactions
    5. Raw Files
    6. Proactive WMI Integration
    7. Building a File Watcher Task
    8. Summary
  15. Deployment
    1. Working with a Team in SSIS
    2. Reusable Packages
    3. Creating a Package Template
    4. Package Configuration
    5. Deployment Utility
    6. Summary
  16. Managing SSIS
    1. The Package Store
    2. Management Studio
    3. Running Packages with DTExecUI
    4. Security
    5. Firewall Issues
    6. Command Line Utilities
    7. Scheduling a Package
    8. Proxy Accounts
    9. 64-Bit Issues
    10. Performance Counters
    11. Summary
  17. Handling Heterogeneous and Unusual Data
    1. Unusual Data Flow Scenarios
    2. Oracle
    3. Other Data Sources
    4. Summary
  18. Migrating from DTS to SSIS
    1. SQL Server 2005 DTS Backward Compatibility
    2. Administering and Editing a DTS Package
    3. Upgrading from DTS
    4. Handling Exceptions
    5. Summary
  19. Scaling SSIS
    1. SSIS Scalability Foundations
    2. Data Flow Optimization
    3. Package Execution Principles
    4. Summary
  20. Index

Product information

  • Title: Expert SQL Server™ 2005 Integration Services
  • Author(s): Brian Knight, Erik Veerman
  • Release date: May 2007
  • Publisher(s): Wrox
  • ISBN: 9780470134115