Database and Infrastructure Architecture and Security
Home for K. Brian Kelley, SQL Server Author and Columnist

 Home

 Articles
  SQL Server Central
  SQL Server Standard
  Other Sources

 Resume
 

Review - Professional SQL Server 2005 Integration Services

Note of Bias: I received a free copy of this book from Kathi Kellenberger, one of the authors, for this review. Also, I count several of the authors among my list of professional contacts.

I remember the first time I discovered Data Transformation Services (DTS) in SQL Server 7.0. I was amazed with the power of this addition to the overall SQL Server database package. Naturally, when I found Professional SQL Server 2000 DTS at the bookstore, I flipped through it to see if it was worth purchasing. An hour or so later, I looked down at my watch, realized the time, and hurried over to purchase the book so I could take it home. It became one of my most valuable SQL Server books, one which I opened up time and time again, much like Rob Viera's Professional SQL Server 7.0 Programming.

Data Transformation Services morphed a bit in SQL Server 2000 but nothing compared to what SQL Server Integration Services is today. When I found out Professional SQL Server 2005 Integration Services was coming out, I decided to put it on my list of books to have. Not knocking the Microsoft Books On-line documentation, which is among the best for any product, but I figured I would get into the nuts and bolts of SSIS a whole lot easier with this book than solely with Books Online.  When I found Brian Knight had posted Chapter 5 on his blog, I downloaded it and took a look. The sample chapter only reaffirmed my thoughts on the value of this book in my library.

What the Book Contains

This is a large book, but then again, SSIS is a large topic. The book chapters break down like this:

  • Chapter 1: Welcome to SQL Server Integration Services
  • Chapter 2: The SSIS Tools
  • Chapter 3: SSIS Tasks
  • Chapter 4: Containers and Data Flow
  • Chapter 5: Creating an End-to-End Package
  • Chapter 6: Advanced Tasks and Transforms
  • Chapter 7: Scripting in SSIS
  • Chapter 8: Accessing Heterogeneous Data
  • Chapter 9: Reliability and Scalability
  • Chapter 10: Understanding the Integration Services Engine
  • Chapter 11: Applying the Integration Services Engine
  • Chapter 12: DTS 2000 Migration and Metadata Management
  • Chapter 13: Error and Event Handling
  • Chapter 14: Programming and Extending SSIS
  • Chapter 15: Adding a User Interface to Your Component
  • Chapter 16: External Management and WMI Task Implementation
  • Chapter 17: Using SSIS with External Applications
  • Chapter 18: SSIS Software Development Life Cycle
  • Chapter 19: Case Study: A Programmatic Example

I'm going to do a fairly in-depth review, therefore, I've broken it up into 4 sections:

 

 
What's New!

Updated:
Resume
February 5, 2008

 

© 2002-2008 by Truth Solutions™ and K. Brian Kelley. All Rights Reserved.
For questions or comments, contact webmaster@truthsolutions.com.
All logos and trademarks are the sole property of their respective owners and are used with permission where required.