Wireless Java : Developing with Java 2, Micro Edition
Wireless Java : Developing with Java 2, Micro Edition
ISBN: 189311550X
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 182
Pages: 182
Authors: Jonathan Knudsen
- Table of Contents
- Back Cover
- Professional SQL Server 2005 Integration Services
- Foreword
- Introduction
- How This Book Is Structured
- What You Need to Use This Book
- Conventions
- Source Code
- Errata
- p2p.wrox.com
- Chapter 1: Welcome to SQL Server Integration Services
- Architecture
- Precedence Constraints
- Containers
- Variables
- Data Flow Elements
- Error Handling and Logging
- Editions of SQL Server 2005
- Summary
- Chapter 2: The SSIS Tools
- Package Installation Wizard
- Business Intelligence Development Studio
- Creating Your First Package
- The Solution Explorer Window
- The SSIS Package Designer
- Summary
- Chapter 3: SSIS Tasks
- Shared Properties
- Execute SQL Task
- Bulk Insert Task
- Using the Bulk Insert and Execute SQL Tasks
- Data Flow Task
- Execute Process Task
- File System Task
- FTP Task
- Using the File System and FTP Task
- Execute Package Task
- Script and ActiveX Tasks
- Send Mail Task
- Message Queue Task
- Web Service Task
- WMI Data Reader and Event Watcher Task
- XML Task
- SQL Server Analysis Services Execute DDL and Processing Tasks
- Data Mining Query Task
- The Expression Page
- Summary
- Chapter 4: Containers and Data Flow
- Sources
- Destinations
- Transformations
- Data Flow Example
- Data Viewers
- Summary
- Chapter 5: Creating an End-To-End Package
- Typical Mainframe ETL with Data Scrubbing
- Looping and the Dynamic Task
- Summary
- Chapter 6: Advanced Tasks and Transforms
- Execute SQL Task
- Import Column
- Using Temp Tables in SSIS Package Development
- Export Column
- Row Count
- OLE DB Command
- Term Extraction
- Term Lookup
- Fuzzy Lookup
- Fuzzy Grouping
- Pivot Transform
- Unpivot
- Slowly Changing Dimension
- Database Object-Level Tasks
- Summary
- Chapter 7: Scripting in SSIS
- Expressions
- Script Tasks
- Using .NET Assemblies
- Structured Exception Handling
- Script Component
- Summary
- Chapter 8: Accessing Heterogeneous Data
- Excel
- Access
- Oracle
- Web Services
- XML Data
- Summary
- Chapter 9: Reliability and Scalability
- Package Transactions
- Error Outputs
- Scaling Out
- Summary
- Chapter 10: Understanding the Integration Services Engine
- The Integration Services Engine: An Analogy
- Understanding the SSIS Data Flow and Control Flow
- Enterprise Workflows with the Control Flow
- Enterprise Data Processing with the Data Flow
- Summary
- Chapter 11: Applying the Integration Services Engine
- That Was Then: DTS
- This Is Now: Integration Services
- Pipeline Performance Monitoring
- Summary
- Chapter 12: DTS 2000 Migration and Metadata Management
- Migrating DTS 2000 Packages to SSIS
- Using the Package Migration Wizard
- Running DTS 2000 Packages under SSIS
- Package Metadata and Storage Management
- Summary
- Chapter 13: Error and Event Handling
- Precedence Constraints
- Event Handling
- Breakpoints
- Checkpoints
- Logging
- Summary
- Chapter 14: Programming and Extending SSIS
- The Sample Components
- The Pipeline Component Methods
- Building the Components
- Debugging Components
- Summary
- Chapter 15: Adding a User Interface to Your Component
- Three Key Steps
- Building the User Interface
- Further Development
- Summary
- Chapter 16: External Management and WMI Task Implementation
- External Management with Managed Code
- Application Object Maintenance Operations
- Package Log Providers
- Package Configurations
- Windows Management Instrumentation Tasks
- Summary
- Chapter 17: Using SSIS with External Applications
- RSS In, Reporting Services Report Out
- InfoPath Document
- ASP.NET Application
- Summary
- Chapter 18: SSIS Software Development Life Cycle
- Introduction to Software Development Life Cycles
- Versioning and Source Code Control
- Code Deployment and Promotion from Development to Test to Production
- Summary
- Chapter 19: Case Study: A Programmatic Example
- Background
- Business Problem
- Solution Summary
- Solution Architecture
- Data Architecture
- Case Study Load Package
- Case Study Process Package
- Running in SQL Agent
- 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
- Z
Wireless Java : Developing with Java 2, Micro Edition
ISBN: 189311550X
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 182
Pages: 182
Authors: Jonathan Knudsen