---

Expert SQL Server 2005 Integration Services (Programmer to Programmer)

ISBN: 0470134119
EAN: 2147483647

Year: 2004
Pages: 111

Authors: Brian Knight, Erik Veerman

BUY ON AMAZON

• Table of Contents
• Back Cover
• Expert SQL Server 2005 Integration Services
• Credits
• Introduction
• 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
• 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
• 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 ETL
• Fact Table ETL Challenge
• Fact Table ETL Basics
• Advanced Fact Table ETL Concepts
• Summary
• Chapter 6: Processing Analysis Services Objects with SSIS
• SSAS Integration Basics Within SSIS
• Advanced Processing and Partition Management Examples
• Summary
• Chapter 7: Package Reliability
• Logging
• Checkpoint Files
• Transactions
• Raw Files
• Proactive WMI Integration
• Building a File Watcher Task
• Summary
• Chapter 8: Deployment
• Reusable Packages
• Creating a Package Template
• Package Configuration
• Deployment Utility
• Summary
• Chapter 9: Managing SSIS
• 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
• Oracle
• Other Data Sources
• Summary
• Chapter 11: Migrating from DTS to SSIS
• 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
• A
• B
• C
• D
• E
• F
• G
• H
• I
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• List of Figures
• List of Listings
• List of Sidebars