Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition

by Ashwani Nanda

Overview

Transform Raw Data Into Meaningful Business Intelligence with SSIS

Deploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource.

• Build SSIS packages using the Import and Export Wizard and Business Intelligence Development Studio
• Create Loop and Task Host Containers with Control Flow Designer
• Administer SSIS from SQL Server Management Studio and dutil
• Secure packages using encryption, roles, signatures, and permissions
• Build-in memory lookups and transformations using the Data Flow Engine
• Extend functionality using custom scripts and ActiveX components
• Use SCD transformations to load data warehouses and data marts
• Learn to build a Star Schema and Parallel Data Warehouse
• Migrate Data Transformation Services 2000 and SSIS 2005 packages

Product Details

ISBN-13:	9780071736411
Publisher:	McGraw Hill LLC
Publication date:	09/22/2010
Sold by:	Barnes & Noble
Format:	eBook
Pages:	608
File size:	16 MB
Note:	This product may take a few minutes to download.

About the Author

Ashwani Nanda, MSTS, MCDBA, MCSE, is a BI developer with Avis-Europe where he focuses on data warehouse and CRM systems development, data integration projects, and business intelligence reporting solutions. He is the author of Hands-On SQL Server 2005 Integration Services.

Table of Contents

Chapter 1. Introducing SSIS; Chapter 2. Import and Export Wizard; Chapter 3. SSIS Workflow Nuts and Bolts; Chapter 4. Control Flow Containers; Chapter 5. Control Flow Tasks; Chapter 6. Administration; Chapter 7. Securing Packages; Chapter 8. Advanced Features; Chapter 9. Data Flow Components; Chapter 10. Data Flow Transformations; Chapter 11. Deploying Packages; Chapter 12. Migrating; Chapter 13. Troubleshooting and Performance Enhancements; Chapter 14. Extending SSIS (New); Chapter 15. Star Schema Data Warehouse Architecture (New)