Hands-On Microsoft Sql Server 2008 Integration Services, Second Edition (DATABASE & ERP - OMG) - Softcover

Nanda, Ashwani

 
9780071736404: Hands-On Microsoft Sql Server 2008 Integration Services, Second Edition (DATABASE & ERP - OMG)
Softcover
ISBN 10: 0071736409 ISBN 13: 9780071736404
Publisher: McGraw-Hill Osborne Media, 2010

Synopsis

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
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

"synopsis" may belong to another edition of this title.

About the Author

McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide

"About this title" may belong to another edition of this title.

Publisher
McGraw-Hill Osborne Media
Publication date
2010
Language
English
ISBN 10 
0071736409
ISBN 13 
9780071736404
Binding
Paperback
Edition number
2
Number of pages
720

Other Popular Editions of the Same Title

9780071074193: Hands - on Microsoft Sql Server 2008 Integration Services

Featured Edition

ISBN 10:  0071074198 ISBN 13:  9780071074193
Softcover