Hands-On Microsoft SQL Server 2008 Integration Services

  • 12h 37m
  • Ashwani Nanda
  • McGraw-Hill/Osborne
  • 2011

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 develops and maintains marketing, analytical, and CRM-based database systems for medium- to large-sized enterprises. His current area of specialization is data modeling, database development, business intelligence reporting, and analysis. He started his career on real-time mainframe systems back in the age when hard disks used to weigh a kilo per megabyte. Moving from system engineering for mainframes to networking and infrastructure support, then to database management and currently to business intelligence, he has worked for several major hardware and software vendors. He loves to integrate disparate technologies utilizing the best features of available applications. These days he is using his business intelligence skills to create data visualization reports.

In this Book

  • Introducing SQL Server Integration Services
  • Getting Started with Wizards
  • Nuts and Bolts of the SSIS Workflow
  • Integration Services Control Flow Containers
  • Integration Services Control Flow Tasks
  • Administering Integration Services
  • Securing Integration Services Packages
  • Advanced Features of Integration Services
  • Data Flow Components
  • Data Flow Transformations
  • Programming Integration Services
  • Data Warehousing and SQL Server 2008 Enhancements
  • Deploying Integration Services Packages
  • Migrating to Integration Services 2008
  • Troubleshooting and Performance Enhancements