Description |
1 online resource (xxi, 404 pages) : illustrations |
Series |
Wrox expert |
|
Wrox expert one-on-one.
|
Contents |
Cover -- About the Authors -- Contributing Author -- Credits -- Acknowledgments -- Contents -- Introduction -- Whom This Book Is For -- What This Book Covers -- How This Book Is Structured -- What You Need to Use This Book -- Conventions -- Source Code -- Errata -- p2p.wrox.com -- Chapter 1: Getting Started -- Choosing the Right Tool for the Job -- SSIS Review -- Summary -- Chapter 2: Extending Scripts in SSIS -- Script Tasks and Custom Libraries -- Building a Custom Assembly -- Making Connections Configurable and Dynamic -- Raising Error Events -- Encrypting Data Through Script Components -- Data Profiling -- Summary -- Chapter 3: Data Extraction -- Package Connections and Data Flow Sources -- Incremental Data Extraction -- Tracking Data Lineage Identifiers -- Summary -- Chapter 4: Dimension ETL with SSIS -- Dimension ETL Overview -- Dimensions: The Basics -- Dimension ETL: The Challenge -- SSIS Slowly Changing Dimension Wizard -- Creating a Custom Slowly Changing Package -- Summary -- Chapter 5: Fact Table ETL -- Fact Table Overview -- Fact Table ETL -- Fact Table ETL Challenge -- Fact Table ETL Basics -- Advanced Fact Table ETL Concepts -- Summary -- Chapter 6: Processing Analysis Services Objects with SSIS -- SSAS ETL Processing and Management Overview -- SSAS Integration Basics Within SSIS -- Advanced Processing and Par tition Management Examples -- Summary -- Chapter 7: Package Reliability -- Error and Event Handling -- Logging -- Checkpoint Files -- Transactions -- Raw Files -- Proactive WMI Integration -- Building a File Watcher Task -- Summary -- Chapter 8: Deployment -- Working with a Team in SSIS -- Reusable Packages -- Creating a Package Template -- Package Configuration -- Deployment Utility -- Summary -- Chapter 9: Managing SSIS -- The Package Store -- Management Studio -- Running Packages with DTExecUI -- Security -- Firewall Issues -- Command Line Utilities -- Scheduling a Package -- Proxy Accounts -- 64-Bit Issues -- Performance Counters -- Summary -- Chapter 10: Handling Heterogeneous and Unusual Data -- Unusual Data Flow Scenarios -- Oracle -- Other Data Sources -- Summary -- Chapter 11: Migrating from DTS to SSIS -- SQL Server 2005 DTS Backward Compatibility -- Administering and Editing a DTS Package -- Upgrading from DTS -- Handling Exceptions -- Summary -- Chapter 12: Scaling SSIS -- SSIS Scalability Foundations -- Data Flow Optimization -- Package Execution Principles -- Summary -- Index -- Last Page. |
Summary |
"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"--Resource description page |
Subject |
SQL server.
|
|
SQL server. |
|
SQL server |
|
Database management.
|
|
Data warehousing.
|
|
Bases de données -- Gestion. |
|
Entrepôts de données (Informatique) |
|
Data warehousing |
|
Database management |
Added Author |
Veerman, Erik, 1973-
|
Added Title |
SQL server 2005 integration services |
Other Form: |
Print version: Knight, Brian, 1976- Expert SQL server 2005 integration services. Indianapolis, IN : Wiley Pub., ©2007 9780470134115 0470134119 (DLC) 2007013520 (OCoLC)85829248 |
ISBN |
9780470179581 (electronic bk.) |
|
0470179589 (electronic bk.) |
|
(Paper) |
|
(paper/website) |
|