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
Similar book on Amazon
Identifying and Managing Project Risk: Essential Tools for Failure-Proofing Your Project
Beginning J2ME: From Novice to Professional
Beginning BlackBerry Development (Books for Professionals by Professionals)
J2ME: The Complete Reference
Introducing Microsoft Office InfoPath 2003 (Bpg-Other)
ADO.NET 3.5 Cookbook (Cookbooks (OReilly))
Connecting to an Access Databasefrom ASP.NET
Retrieving Data from an Oracle Package
Localizing Client-Side Data in a Web Forms Application
Selecting the Top n Rows in a DataTable
Exporting the Results of a Query to an Array
Interprocess Communications in Linux: The Nooks and Crannies
File Information
Summary
Introduction
Key Terms and Concepts
Using Signals in Threads
SQL Hacks
Joins, Unions, and Views
Hack 8. Filter Rows and Columns
Online Applications
Hack 59. Define Personalized Parameters
Hack 94. Create Users and Administrators
Cisco Voice Gateways and Gatekeepers
H.323
Digit Manipulation
Call Admission Control
Configuring Class of Restrictions
Multiple Gatekeeper Configurations
Lotus Notes Developers Toolbox: Tips for Rapid and Successful Deployment
Domino Design Elements
Working with Application Menus
Limit the Ability to Create Documents on a Local Database
Expand and Collapse All Document Sections
Create a New Document
Junos Cookbook (Cookbooks (OReilly))
Viewing Traffic Statistics on an Interface
Introduction
Enabling OSPF Authentication
Restricting the Number of Routes Advertised to a BGP Peer
Setting Up a Simple Layer 3 VPN
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