Hands-On Microsoft SQL Server 2005 Integration Services / Edition 1

Paperback (Print)
Buy Used
Buy Used from BN.com
$31.17
(Save 41%)
Item is in good condition but packaging may have signs of shelf wear/aging or torn packaging.
Condition: Used – Good details
Eligible for FREE SHIPPING details
Usually ships within 24 hours details
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 96%)
Other sellers (Paperback)
  • All (33) from $1.99   
  • New (5) from $6.93   
  • Used (28) from $1.99   

More About This Textbook

Overview

Build robust, high-performance Business Intelligence solutions with SSIS

Extract, transform, and consolidate data from disparate sources and move it to single or multiple destinations using SQL Server 2005 Integration Services — the next-generation data integration platform. Hands-On Microsoft SQL Server 2005 Integration Services shows you, step-by-step, how to build and manage SSIS packages, draw out meaningful information from raw data, and deliver de-duplicated and cleansed data to business applications and corporate reports. Inside, you'll get detailed information on migrating to SQL Server 2005 Integration Services, enhancing performance, and implementing encryption policies to secure SSIS packages.

ESSENTIAL SKILLS FOR DATABASE PROFESSIONALS:

  • Build packages with the SSIS Import and Export Wizard and BIDS
  • Create expressions using variables, functions, and operators
  • Lay out package workflow with Control Flow Containers and tasks
  • Secure SSIS packages and encrypt sensitive data
  • Monitor and audit runtime events using log providers
  • Respond to external triggers with event handlers
  • Transform and manipulate input using Data Flow Components
  • Standardize, de-duplicate, and cleanse data with Fuzzy Lookup and Fuzzy Grouping transformations
  • Load Data warehouse using Slowly Changing Dimension transformation
  • Deploy, optimize, troubleshoot, and debug SSIS packages
Read More Show Less

Product Details

  • ISBN-13: 9780072263190
  • Publisher: McGraw-Hill Professional Publishing
  • Publication date: 8/28/2006
  • Edition number: 1
  • Pages: 570
  • Product dimensions: 1.20 (w) x 9.69 (h) x 7.44 (d)

Meet 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 management, data analysis, and visualization. He started his career on the 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 and currently to data practice, he has worked for several major hardware and software vendors. He has loved to network and integrate disparate technologies, with particular attention to productivity and security. These days he is using his integration skills with RDBMS databases and end-user tools. He can be reached at ananda@AffordingIT.co.uk.

Read More Show Less

Table of Contents

Ch. 1 Introducing SQL server integration services 1
Ch. 2 SQL server import and export wizard 31
Ch. 3 Nuts and bolts of the SSIS workflow 59
Ch. 4 Integration services control flow containers 93
Ch. 5 Integration services control flow tasks 121
Ch. 6 Administrating integration services 211
Ch. 7 Securing integration services packages 249
Ch. 8 Advanced features of integration services 273
Ch. 9 Data flow components 311
Ch. 10 Data flow transformations 355
Ch. 11 Deploying integration services packages 455
Ch. 12 Migrating to integration services 483
Ch. 13 Troubleshooting and performance enhancements 517
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)