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

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.

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

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

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

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.