Databases (Access, SQL Server ...) SQL SERVER 2005

 Microsoft SQL Server 2005 Integration Services Step-By-Step

Published by: MICROSOFT PRESS
Author: Turley, Paul; Kasprzak, Joe; Cameron, Scott; Iizuka, Satoshi; Guzman, Pablo;
Group: SQL SERVER 2005
ISBN: 0735624054
ISBN 13: 9780735624054
Number of pages: 453
User level: Programmer - Beg/Int
Objective: Tutorial Date Published: Jun 2007
 RRP £35.49 Save 35%
 Online Price £23.06

 Book Information

Teach yourself the fundamentals of SQL Server Integration Services - one step at a time. This practical, learn-by-doing tutorial delivers the guidance you need to transform and consolidate data - and build solutions that support your business intelligence needs.

Discover how to:
* Design and execute packages that transform data between files and relational databases
* Configure connection managers to access other data sources
* Create data flows that alter, split, match, and merge data
* Develop event-handlers and monitor package performance
* Encrypt sensitive information and control access to packages
* Customize script code to automate Control Flow and Data Flow tasks
* Debug, troubleshoot, and optimize packages
CD features:
* All practice exercises
* Sample databases
* Fully searchable eBook

IntroductionGetting Started with Integration Services
* Chapter 1: Introduction to SQL Server Integration Services
* Chapter 2: Building Your First PackageDesigning Packages
* Chapter 3: Extracting and Loading Data
* Chapter 4: Using Data Flow Transformations
* Chapter 5: Managing Control Flow
* Chapter 6: Scripting Tasks
* Chapter 7: Debugging Packages
* Chapter 8: Managing Package ExecutionManaging Packages
* Chapter 9: Detecting and Handling Processing Errors
* Chapter 10: Securing and Deploying SSIS Packages
* Chapter 11: Optimizing SSIS PackagesApplying SSIS to Data Warehousing
* Chapter 12: Data Warehouse Concepts
* Chapter 13: Populating Data Warehouse Structures
* Chapter 14: SSIS General PrinciplesAbout the AuthorsFor Web DevelopersAdditional SQL Server Resources for Developers