Flylib.com
Wireless Java : Developing with Java 2, Micro Edition
Wireless Java : Developing with Java 2, Micro Edition
ISBN: 189311550X
EAN: 2147483647
Year: 2006
Pages: 182
Authors:
Jonathan Knudsen
BUY ON AMAZON
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
Year: 2006
Pages: 182
Authors:
Jonathan Knudsen
BUY ON AMAZON
Metrics and Models in Software Quality Engineering (2nd Edition)
The Spiral Model
The Object-Oriented Development Process
Metrics and Lessons Learned for Object-Oriented Projects
Customer Satisfaction Surveys
Software Quality Engineering Modeling
Identifying and Managing Project Risk: Essential Tools for Failure-Proofing Your Project
Planning for Risk Management
Identifying Project Scope Risk
Managing Activity Risks
Quantifying and Analyzing Project Risk
Appendix A Selected Detail From the PERIL Database
Lotus Notes and Domino 6 Development (2nd Edition)
Whats New in Release 6?
Advanced Form Design
Creating Shared Actions
Creating Web Agents Using Formulas and LotusScript
Syntax and Command Blocks
PMP Practice Questions Exam Cram 2
Exam Prep Questions
Answers and Explanations
Answers and Explanations
Answers and Explanations
Appendix A. CD Contents and Installation Instructions
Cultural Imperative: Global Trends in the 21st Century
Cross-Century Worldviews
Cultural Spectacles
The China Phenomenon
Empires Past, Present, and Future
Appendix C National Traits
MPLS Configuration on Cisco IOS Software
EIGRP PE-CE Routing Protocol Overview, Configuration, and Verification
Command Reference
MPLS TE Theory
Local Switching
MPLS QoS Implementation
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies