Home › Computers › Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition

Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition

by Ashwani Nanda

A practical guide to building and administering SSIS 2008 solutions

Regular price $46.96 USD
Regular price $78.27 USD Sale price $46.96 USD
Save 40%

Paperback New English

Delivery to your door
In stock·Dispatches in 1–2 business days
Standard shipping* from $4.35
Standard shipping transit* 5–8 business days after dispatch

Faster options are available.

Rates and delivery estimates depend on your destination and item quantity. Estimates are informational only; the final shipping method and rate are selected at checkout.

Secure checkout
American Express Apple Pay DiscoverGoogle Pay Mastercard PayPalVisa
30-day eligible returns Returns & refunds policy

AlbakiReads Editorial

A practical guide to building and administering SSIS 2008 solutions

Focused on Microsoft SQL Server 2008 Integration Services, this second edition organizes its coverage around the work of turning disparate organizational data into managed transformation workflows. It addresses package creation through the Import and Export Wizard and Business Intelligence Development Studio, then moves into control flow, data cleansing, in-memory lookups, transformations, security, administration, and performance optimization. The book also covers data-warehouse work, including slowly changing dimensions, star schemas, and parallel data warehousing, alongside migration from earlier DTS and SSIS packages. Exercises, illustrations, and applied examples support its step-by-step technical scope.

Good fit for readers who enjoy

  • Database professionals working with SQL Server 2008 Integration Services
  • Developers building ETL packages, data flows, and warehouse-loading processes
  • Teams migrating DTS 2000 or SSIS 2005 packages

Themes

ETL and data transformationSSIS package developmentData cleansing and workflowDatabase security and administrationData warehousing and migration

Based on publisher information and book metadata.

Book overview

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
Shipping & returnsShipping options, delivery timing, and our return policy.

In-stock items normally dispatch within 1–2 business days. The ZIP-code estimator on this page is informational only; the final shipping method, price, and availability are confirmed at checkout for your full order.

For the initial delivery estimate we use these transit windows after dispatch: Standard 5–8 business days, Expedited 2–4 business days, and Priority 1–2 business days. Holiday delays are not included.

Eligible items can be returned within 30 days in accordance with our return policy.

Customer reviews