Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition [NOOK Book]

Be the first to write a review

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 ...

See more details below
Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$62.00
BN.com price

More About This Book

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

Read More Show Less

Product Details

  • ISBN-13: 9780071736411
  • Publisher: McGraw-Hill Education
  • Publication date: 9/2/2010
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 2
  • Pages: 720
  • File size: 16 MB
  • Note: This product may take a few minutes to download.

Meet 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.

Read More Show Less

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
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)
    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)