Hands-on Microsoft SQL Server 2005 Integration Services

Build robust, high-performance Business Intelligence solutions with SSISExtract, 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 Servicesshows 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 packagesNanda, Ashwani is the author of 'Hands-on Microsoft SQL Server 2005 Integration Services ', published 2006 under ISBN 9780072263190 and ISBN 0072263199.