Microsoft SQL Server 2005 Integration Services (SQL Server Series) (Paperback)

by Kirk Haselden (Author)

Editorial Reviews

Product Description

All medium to large companies have to deal with data being stored in a number of databases, spreadsheets and proprietary applications. Bringing all this data together into one system can be useful to analyzing the business; but can also be quite difficult to do. Integration Services is the next big bet in Microsoft's business intelligence lineup, providing you with true enterprise extract transform and load features (ETL).

 

Microsoft SQL Server 2005 Integration Services concentrates on providing you with real world solutions to real world problems, giving you a head start on various projects. If you are only evaluating Integration Services, you'll be able to focus on the early chapters with the option of drilling down into details in the later chapters where some of the more complex concepts will be discussed in detail. The interesting sidebars peppered throughout the book provide insight into the processes, people and decisions that yielded the final IS product.

About the Author
Kirk Haselden is the Group Program Manager for the Microsoft Master Data Management product forthcoming in the next wave of Office SharePoint Services and owns the long term strategy, vision, planning and development of that product. Kirk has been with Microsoft for 12 years in various groups including Hardware, eHome, Connected Home, SQL Server and Office Business Platform. He was the development manager for Integration Services and the primary designer for the runtime and many of the tasks. Prior to Microsoft, Kirk worked for several small startup companies building educational, dental and online software. Kirk has a BA in Accounting and Information Systems from the University of Utah. He has written a number of articles for SQL Server Magazine, speaks regularly at industry events, writes profusely on his personal and MSDN blog, and holds 35 patents or patents pending. Kirk is married and the father of five wonderful children. He enjoys family time, photography, snow skiing, wake boarding, racquetball, motorcycle riding, hiking, breathing, drinking, and eating. He’s always wearing hideous Hawaiian shirts, shorts, and sandals, except in the winter, when he also wears socks. He once lived in Wichita, Kansas and thinks it’s funny when people talk about themselves in third person.

See all Editorial Reviews

Product Details

• Paperback: 888 pages
• Publisher: Sams; 1 edition (July 31, 2006)
• Language: English
• ISBN-10: 0672327813
• ISBN-13: 978-0672327810
• Product Dimensions: 8.5 x 7 x 1.7 inches
• Shipping Weight: 2.4 pounds (View shipping rates and policies)
• Average Customer Review: 3.6 out of 5 stars See all reviews (23 customer reviews)
• Amazon.com Sales Rank: #376,063 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

8 of 8 people found the following review helpful:

2.0 out of 5 stars Not sure what to say . . ., April 30, 2007

By	M. Loftus - See all my reviews (REAL NAME)

I spent several days trying to get the very first exercise to work, but failed. (Screen prints in the book are different than the printed instructions.) I then downloaded the examples from Sam's Publishing only to find that some of the coding is different than what the book shows. But the examples do work properly and are very helpful. I have to say that the book does seem to cover lots of material in detail and I am reading it cover-to-cover. There are lots of tid-bits which will save a lot of hair-pulling.

3 of 3 people found the following review helpful:

3.0 out of 5 stars A reference book, not a tutorial, August 16, 2007

By	Anhnhat Tran "CSUN Graduate" (Northridge, CA USA) - See all my reviews (REAL NAME)

I am a developer and it is the first time I learn about this topic. I would like to jump in and start coding right away. Most of the time, the author explains the topic by using screenshots without working samples. This book may be used as a reference book if you already has experiences with Integration Services. It is definitely not a tutorial book.

11 of 15 people found the following review helpful:

5.0 out of 5 stars Exceptionally valuable and detailed book, September 29, 2006

By	Steven Rosen (Springfield, PA United States) - See all my reviews (REAL NAME)

Having used DTS for many years, the transition to serious use of SSIS has
proven to be quite "challenging"...yea, that's the word. In fact, SSIS,
is a quantum leap in complexity and mindset above using DTS. It has
been many quirks, subtleties and rituals required to use it effectively.
While not 100% mature, it is very sophisticated and a powerful tool
for ETL tasks.

This book has proven to be very detailed for my needs and covers
almost all aspects of SSIS in extensive detail. It adequately explans all tasks
and how to use most every aspect and feature in creating and deploying SSIS solutions. It also
gives solid insight on best practices and guidelines on how specific
features are intended to work and not work.

The only way to really get going with SSIS is to have a comprehensive
reference so that you can understand using the tool to the greatest
degree possible. Highly recommended, very readable and useful.