Hands-On Microsoft SQL Server™ 2005 Integration Services

Overview

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.

Table of contents

Chapter 1: Introducing SQL Server Integration Services
Chapter 2: SQL Server Import and Export Wizard
Chapter 3: Nuts and Bolts of the SSIS Workflow
Chapter 4: Integration Services Control Flow Containers
Chapter 5: Integration Services Control Flow Tasks
Chapter 6: Administrating Integration Services
Chapter 7: Securing Integration Services Packages
Chapter 8: Advanced Features of Integration Services
Chapter 9: Data Flow Components
Chapter 10: Data Flow Transformations
Chapter 11: Deploying Integration Services Packages
Chapter 12: Migrating to Integration Services
Chapter 13: Troubleshooting and Performance Enhancements
APPENDIX: HOW TO USE THE PROVIDED SOFTWARE
INDEX

Biographical note

Ashwani Nanda develops and maintains marketing, analytical, and CRM-based database systems for medium- to large-sized enterprises. His current area of specialization is data modeling, database management, data analysis, and visualization. He started his career on the real-time mainframe systems back in the age when hard disks used to weigh a kilo per megabyte. Moving from system engineering for mainframes to networking and infrastructure support and currently to data practice, he has worked for several major hardware and software vendors. He has loved to network and integrate disparate technologies, with particular attention to productivity and security. These days he is using his integration skills with RDBMS databases and end-user tools. He can be reached at ananda@AffordingIT.co.uk.

Back cover copy

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