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
Crystal Reports 9 on Oracle (Database Professionals)
Connectivity, Authentication, and Privileges
Oracle Advanced SELECT Options
Optimizing: The Crystal Reports Side
Optimizing: The Oracle Side
Appendix B Functions
Cisco IP Communications Express: CallManager Express with Cisco Unity Express
The Cisco 7940G and 7960G IP Phones
Troubleshooting Basic Cisco IPC Express Features
The main.aef Script
Table vm_message
Table vm_usermsg
Systematic Software Testing (Artech House Computer Library)
Detailed Test Planning
The Test Organization
The Test Manager
Appendix A Glossary of Terms
Appendix E Simplified Unit Test Plan
Managing Enterprise Systems with the Windows Script Host
Introduction
Application Automation
Network Administration/WMI
Internet Applications
Exchange Server
PMP Practice Questions Exam Cram 2
Answers and Explanations
Exam Prep Questions
Answers and Explanations
Answers and Explanations
Exam Prep Questions
The Lean Six Sigma Pocket Toolbook. A Quick Reference Guide to Nearly 100 Tools for Improving Process Quality, Speed, and Complexity
Using DMAIC to Improve Speed, Quality, and Cost
Value Stream Mapping and Process Flow Tools
Descriptive Statistics and Data Displays
Identifying and Verifying Causes
Selecting and Testing Solutions
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