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
A Practitioners Guide to Software Test Design
Boundary Value Testing
State-Transition Testing
Use Case Testing
Section III - Testing Paradigms
Exploratory Testing
Microsoft Windows Server 2003(c) TCP/IP Protocols and Services (c) Technical Reference
Wide Area Network (WAN) Technologies
Address Resolution Protocol (ARP)
Internet Group Management Protocol (IGMP)
Transmission Control Protocol (TCP) Connections
Transmission Control Protocol (TCP) Data Flow
Service-Oriented Architecture (SOA): Concepts, Technology, and Design
Web Services and Primitive SOA
Orchestration
Metadata exchange
Business service layer
Appendix B. Service Models Reference
GO! with Microsoft Office 2003 Brief (2nd Edition)
Using Special Document Formats, Columns, and Mail Merge
Objective 3. Enter and Edit Data in a Worksheet
Access 2003
Key Terms
Project 2A. Teenagers
Java Concurrency in Practice
Sharing Objects
Thread Confinement
Avoiding Liveness Hazards
Performance Considerations
Initialization Safety
Microsoft Visual Basic .NET Programmers Cookbook (Pro-Developer)
Strings and Regular Expressions
Objects, Interfaces, and Patterns
Windows Programming
ADO.NET
ASP.NET Web Applications
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