3/01/2011

Hands-On Microsoft SQL Server 2008 Integration Services, 2nd Edition - PDF

Hands On Microsoft SQL Server 2008 Integration Services, 2nd EditionBook 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

Book Details

  • Paperback: 720 pages
  • Publisher: McGraw-Hill Osborne Media; 2nd Edition (September, 2010)
  • Language: English
  • ISBN-10: 0071736409
  • ISBN-13: 978-0071736404
  • File Size: 18.2 MiB
  • Hits: 2,196 times