Hands-On Microsoft SQL Server 2008 Integration Services

Hands-On Microsoft SQL Server 2008 Integration Services

Paperback

By (author) Ashwani Nanda

$41.79
List price $61.26
You save $19.47 31% off

Free delivery worldwide
Available
Dispatched in 3 business days
When will my order arrive?

  • Publisher: Osborne/McGraw-Hill
  • Format: Paperback | 720 pages
  • Dimensions: 185mm x 226mm x 38mm | 1,134g
  • Publication date: 1 October 2010
  • Publication City/Country: New York
  • ISBN 10: 0071736409
  • ISBN 13: 9780071736404
  • Edition: 2, Revised
  • Edition statement: 2nd Revised edition
  • Illustrations note: ill
  • Sales rank: 902,960

Product description

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

Other books in this category

Showing items 1 to 10 of 10
Categories:

Author information

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

Table of contents

Chapter 1 Introducing SQL Server Integration Services Chapter 2 Getting Started With Wizards 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 Programming Integration Services Chapter 12 Data Warehousing and SQL Server 2008 Enhancements Chapter 13 Deploying Integration Services Packages Chapter 14 Migrating to Integration Services 2008 Chapter 15 Troubleshooting and Performance Enhancements Appendix How to Use the Provided Software