- Paperback: 888 pages
- Publisher: Sams Publishing; 1 edition (July 31, 2006)
- Language: English
- ISBN-10: 0672327813
- ISBN-13: 978-0672327810
- Product Dimensions: 7.1 x 1.9 x 9.2 inches
- Shipping Weight: 2.4 pounds (View shipping rates and policies)
- Average Customer Review: 27 customer reviews
- Amazon Best Sellers Rank: #4,124,061 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Microsoft SQL Server 2005 Integration Services 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
From the Back Cover
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.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
Kirk's book is deeper. It explains more of the concepts - from the toolmakers point of view - that accompany the keystrokes; more of the architecure of the tool, why it works the way it does. The benefits of this understanding- for the tool user - are significant.
My analogy is driving a car. Do you NEED to know how the engine and drive train work to drive to the corner store? No. But could a profesional driver succeed without that knowledge? Not a chance. So learn the engine and drive train, in addition to where the pedals and horn button is, and be a pro at SSIS.
Your manager and your peers WILL notice...
Page 191, Chapter 9, Using Expressions, First paragraph
"Appendix B, Expression Syntax and Cookbook, covers more detailed descriptions of expression evaluator functions and syntax."
I have yet to find any Appendix. The one mentioned above looks like it would be very helpful. It would be nice if this was published as a PDF download or errata sheet.
It met my expectations for a good technical book without being extra-ordinary good as reference nor training book. Those are rare because it is almost an impossible feat to accomplish that in a single book.
I prefer myself to have a very well reference handy for every day use and a well structured but also "leading" training book with optional chapters with background info to get a smooth start into new technologies, methods and programing languages.
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.
I finally had to bite the bullet and get with the program; for me Books Online was hopeless, 'way too fragmented, if I could even find the topic that I was looking for. I disagree with a previous reviewer, this is not just a reference book, this is reference + tutorial. If you need to build an FTP task, for instance, pop over to page 151 and start following the directions. As Kirk works through the description of how to set it up, he explains why he's doing what he's doing. I'm finding this book to be one of the most valuable in my SQL 2005 collection.