Hands-On Microsoft SQL Server(tm) 2005 Integration Services

by Ashwani Nanda

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. In-depth... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0072263199
• ISBN13: 9780072263190
• Release Date: September 2006
• Publisher: McGraw-Hill Companies
• Length: 570 Pages
• Weight: 2.30 lbs.
• Dimensions: 1.0" x 7.0" x 9.0"

Customer Reviews

Great book, like a personal tutor

This book chapter by chapter teaches you fundamental concept and follows it up by practical application of what you have learned. The result is that you are in tune with the SSIS each progressing chapter and confident of applying that at your workplace. By devoting most of the pages to hands on exercise, the author does not sacrifice valuable technical concepts and definitions, thus book also serves as a reference book. I recommend such books written by actual professionals than 600+ page book of just theory which leaves the practical application to the imagination of reader.

Half-star off for a questionable title, but beyond that, a gem for those new to SSIS

There is no question that the title should clearly indicate that this is a book for those new to SSIS. (And considering SSIS is such a quantum leap from DTS, there are MANY folks at that stage). However, the book deserves 4-5 stars for what it provides. Giving the book 1-star, because of the title, detracts from the true value of the book. There aren't many books that contain full hands-on exercises. If someone is fairly new to SSIS, THIS is the book to get. This is the closest I've seen to an exercise-driven training manual, in commercial trade paperback form. There are a series of 8-10 page walk-throughs on such topics as aggregation, processing dupes, loading SCDs, pivoting source data, ADO enumerators, etc. In my opinion, the entire Database Professional Series from Osborn McGraw Hill is very strong. If someone already knows the fundamentals of SSIS and wants to go to the next level, get the Wrox Expert SSIS book. Kevin

Good Book

This book is a good one. It brings a new SSIS user to speed quickly. The author has done a good job.

Great Book to learn SSIS Quickly

Hi All, I bought this book because i need to implement my project in SSIS.This book is good for on Job reference , for Beginners and For who has exposure to DTS 2000.I learned and implemented my projected with no time.I recommend this book for those who want to Know about SSIS Quickly. Thanks, Madhu

Hands On Throughout the Entire Book

The title for this book is true, it is Hands-On. Some books just rehash the SQL Books Online but this one provides tons of hands on excercises. Here are just a few. Importing a Flat File into SQL Server 2005 Using System Variables to Create Custom Logs Using Expressions to Update Properties at Run-time Contacting Opportunities (Includes steps necessary for enabling SMTP from a package) Removing Duplicate Email Addresses Consolidating Workflow Packages Reading the Application Log Managing Storage of Integration Services Package Using dtutil Running an SSIS Package Using the Package Execution Utility Understanding Package Protection Levels Beyond the Hands On Exercises the book also is based around a database other than the standard Northwind, pubs or AdventureWorks databases for a little variety. Finally the book covers deployment of your Integration Services Packages and also how to migrate from SQL Server 2000 Data Transformation Services.