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.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Microsoft SQL Server 2005 Integration Services 1st Edition

3.7 out of 5 stars 27 customer reviews
ISBN-13: 075-2063327814
ISBN-10: 0672327813
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used On clicking this link, a new layer will be open
$4.23 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$64.99 On clicking this link, a new layer will be open
More Buying Choices
22 New from $27.69 27 Used from $0.22
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Save Up to 90% on Textbooks Textbooks
$64.99 FREE Shipping. Usually ships within 2 to 4 weeks. Ships from and sold by Amazon.com. Gift-wrap available.

Editorial Reviews

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.
NO_CONTENT_IN_FEATURE



Product Details

  • 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: 3.7 out of 5 stars  See all reviews (27 customer reviews)
  • Amazon Best Sellers Rank: #2,656,559 in Books (See Top 100 in Books)

More About the Author

I'm currently an Architect in Office in the Business Applications group working on an unannounced project.
I've been working at Microsoft in various capacities for over 10 years and enjoy building teams and developing new products. Every project I've ever worked on has been a technical version 1.0 release.

Customer Reviews

Top Customer Reviews

Format: Paperback Verified Purchase
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.
1 Comment 9 of 9 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
If you are looking for an Step-by-Step type book (which apparently quite a few reviewers are) this is not it. What it does is provide you with a very detailed understanding of SSIS. That said, I still was able to go from never using SSIS to having a fairly good working knowledge using nothing but this book in about a week and a half, so I'm not exactly sure what the issue others had is. If you're willing to learn the concepts and apply them on your own, I think you'll find this to be an invaluable resource. A year and a half later I still use it to look something or other up about once a week and it never disappoints.
Comment 4 of 4 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
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.
Comment 11 of 14 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
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.
Comment 3 of 3 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
I have experience building simple DTS packages in SQL Server 2000, so when 2005/2008 hit the market, I was really confused. I'm not a VB programmer; I vastly prefer the Management Studio/Query Analyzer interface over other GUIs in the SQL Server environment, and where the heck did my Import/Export Wizard go? Thank you, Kirk, for explaining that first! I would advise reading Chapter 2, Setting up Integration Services.
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.
Comment 2 of 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
Being an old DTS saw I was pretty thrown by the division of labor between Control Flow and Data Flow. I mean I understood it conceptually but didn't "get it" practically during design time - and to be honest I was a bit intimidated by all the new features too. This book was just what I needed to get comfortable with SSIS. It walked me through the features at the right level of detail and will be a key resource for me going forward.

Note that there are a couple of 'publisher errors' in the book such as missing Appendicies but the quality of information is still great.
Comment 9 of 12 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
I'm new to SSIS. I cannot put this book down! The flow is great (probably because it is written by a single author). Chapter 4 Quickstart was a fantastic way of learning the basics of SSIS very quickly. I only started reading it this week and I'm already half way through it!
Comment 4 of 5 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
I bought this book in late 2006 as migrating from DTS to SSIS. It was the best rated SSIS book back in late 2006, guess those reviewers had different expectations from mine. Although this book gave me overview of each feature of SSIS, it did not help me much for doing actual projects past year. I learned more about specifics of using SSIS from internet (googling about functions or properties) than this book.

I totally agree with some reviewers saying that this is a paper version of BOL. If you are looking for some simple overview of SSIS, this may be the one for you.
Comment 1 of 1 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews