Hands-On SQL Server 2005 Integration Services

Customers who bought this, also bought: Introducing Microsoft LINQ (Paperback) LINQ in Action The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset MCTS Self-Paced Training Kit (Exam 70-445) Bk/CD/DVD: Microsoft SQL Server 2005 Business Intelligence Implement & Maintain Building The Data Warehouse Data Mining with Sql Server 2005 Pro ASP.NET 3.5 in C# 2008, Second Edition Learning WCF Microsoft SQL Server 2005 Reporting Services 2005 Mastering Data Warehouse Design: Relational and Dimensional Techniques

by: Ashwani Nanda

On-line Price: $65.95 (includes GST) Paperback package 570 20%Off Retail Price You save: $17.00 _____________________ N.Sydney : In Stock	Retail Price: $82.95 Publisher: MCGRAW-HILL,28.8.2006 Category: SQL PROGRAMMING Level: ISBN: 0072263199 ISBN13: 9780072263190
Add to Shopping Cart

In-depth coverage of Microsoft's powerful new data integration tool

Learn to maximize the features of SQL Server 2005 Integration Services from this essential guide. Hands-On Microsoft SQL Server 2005 Integration Services makes learning SSIS easy through the use of extensive real-world exercises structured around every component within the tool. You will learn to collect corporate data from various sources and transform that data for analysis, mining, and reporting.

From the Back Cover
Build robust, high-performance Business Intelligence solutions with SSIS
Extract, transform, and consolidate data from disparate sources and move it to single or multiple destinations using SQL Server 2005 Integration Services -- the next-generation data integration platform. Hands-On Microsoft SQL Server 2005 Integration Services shows you, step-by-step, how to build and manage SSIS packages, draw out meaningful information from raw data, and deliver de-duplicated and cleansed data to business applications and corporate reports. Inside, you'll get detailed information on migrating to SQL Server 2005 Integration Services, enhancing performance, and implementing encryption policies to secure SSIS packages.

ESSENTIAL SKILLS FOR DATABASE PROFESSIONALS:

Build packages with the SSIS Import and Export Wizard and BIDS
Create expressions using variables, functions, and operators
Lay out package workflow with Control Flow Containers and tasks
Secure SSIS packages and encrypt sensitive data
Monitor and audit runtime events using log providers
Respond to external triggers with event handlers
Transform and manipulate input using Data Flow Components
Standardize, de-duplicate, and cleanse data with Fuzzy Lookup and Fuzzy Grouping transformations
Load Data warehouse using Slowly Changing Dimension transformation
Deploy, optimize, troubleshoot, and debug SSIS packages