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

Nanda, Ashwani

ISBN 10: 0071736409 / ISBN 13: 9780071736404

Published by McGraw-Hill Osborne Media, 2010

About this Item

Most items will be dispatched the same or the next working day. A copy that has been read but remains in clean condition. All of the pages are intact and the cover is intact and the spine may show signs of wear. The book may have minor markings which are not specifically mentioned. SIGNED BY AUTHOR (unverified).

Seller Inventory # mon0020860586

Bibliographic Details

• Title: Hands-On Microsoft Sql Server 2008 Integration Services, Second Edition (DATABASE & ERP - OMG)
• Publisher: McGraw-Hill Osborne Media
• Publication Date: 2010
• Language: English
• ISBN 10: 0071736409
• ISBN 13: 9780071736404
• Binding: Soft cover
• Edition: 2nd Edition
• Condition: Good
• Weight: 1134 grams

About this title

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

About the Author

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.