Expert SQL Server 2005 Integration Services (Programmer to Programmer)
Expert SQL Server 2005 Integration Services (Programmer to Programmer)
ISBN: 0470134119
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 111
Pages: 111
Authors: Brian Knight, Erik Veerman
- 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
Expert SQL Server 2005 Integration Services (Programmer to Programmer)
ISBN: 0470134119
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 111
Pages: 111
Authors: Brian Knight, Erik Veerman