Expert SQL server 2005 integration services / Brian Knight, Erik Veerman.

Format:

Book

Author/Creator:

Knight, Brian, 1976-

Contributor:

Veerman, Erik, 1973-

Series:

Wrox expert one-on-one.

Wrox expert

Language:

English

Subjects (All):

SQL server.

Database management.

Data warehousing.

Physical Description:

1 online resource (430 p.)

Edition:

1st edition

Other Title:

SQL server 2005 integration services

Place of Publication:

Indianapolis, IN : Wiley Pub., c2007.

Language Note:

English

System Details:

text file

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.

Contents:

Expert SQL Server 2005 Integration Services; 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 ProfilingSummary; 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 OverviewSSAS 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 UtilitiesScheduling 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

Notes:

"Wrox programmer to programmer"--Cover.

Includes index.

ISBN:

9786610900640

9781280900648

1280900644

9780470179581

0470179589

OCLC:

437182332