| Expert SQL Server 2005 Integration Services (Programmer to Programmer) |
|
Product Details
As a practical guide for Integration Services ETL development, this book shows you ways to implement your ETL solution requirements from the data to the administration and everything in-between. Each chapter begins with a review of pertinent ETL concepts and moves into working those out into a design with multiple examples and related Integration Services features with the end goal of putting it all together to get a solution.
Product Reviews
 (5 stars) - Great Book for people with some previous SSIS experience
I have some basic knowledge of SSIS and bought this book so that I could use it to reference and learn from when my company asked me to take on some extra work with regards to SSIS. I was quite pleased to see how well written and how easy it is to follow, and the author definitely knows his target audience. If you are a brand new user looking at this book to jump start into SSIS, I would recommend their other title that comes with the video CD/DVD. This book assumes that you have the basics of SSIS down cold and want to start really getting into the minutia of what it can do.
Highly recommended this book as I can usually find myself highly recommending a lot of the WROX material.
 (4 stars) - Good example and material
Book is well written and considered the real world issue and work.
I am giving 4 star because it could be better by including more real world example and other features of SSIS.
But its good reference if you have basic knowledge and want to build complex solution.
(4 stars) - Forged from developing production ETL systems
This book was written a year or so after SSIS 2005 was released. It has some good best practice information forged from developing production ETL systems with SSIS. Some of the books released at the time of the product release lacked that perspective. I recommend this book.
 (2 stars) - Misleading title. Might be good for BI+OLAP work, but lousy as a generalist reference.
Understand the 2 stars - they have nothing to do with the value or not of this book as a guide to doing Business Intelligence work with SSIS. I have _no_ opinion on that subject.
What I bought this book for was as an SSIS reference, for an ETL project I am working on. Now, if this book was titled "Advanced _Business_ _Intelligence_ using SSIS" I wouldn't have bought it. I researched this book in advance, and might have bought the companion Professional SQL Server 2005 Integration Services (Programmer to Programmer), if that book, also by WROX, hadn't generally been panned by its reviewers.
The focus of this book is to provide enough background to do advanced BI work. Yes, that does include concepts like deploying and debugging. It is probably good at that job, which is why it gets good reviews. Hey, it almost got me interested in BI. But there is surprisingly little outside of the BI target audience's interest. As a result, I've pretty much had to rely on Google, Google Groups and BOL (yeccch) instead of this book - every time I tried to look something up, I found it not to be covered.
An example of how thorough it is in general SSIS, non BI-coverage?
From p.19
"One of the most important types of container is the ForEachLoop container. With this container..."
OK, so this is one of the most important concepts, right? Yes, and it gets 2 paragraphs worth of coverage in the whole book, none of which tell you how to use it. 200 words, at most, to cover "one of the most important" types of container and they also consider containers to be important.
In case you wonder, I want to loop through a rowset and fire off Execute SQL tasks to update or insert rows in a another database. While we are at it, SQL Tasks are also a subject deemed beneath the interest of this book.
Way to go Wrox!
The 3rd lame WROX book I've gotten and I am getting tired of the series. 'Programmer to Programmer', perhaps, but without the benefit of an editor in between, for sure.
p.s. Again, please disregard my review if you want to do BI work. This review only applies if you have a wider focus than BI-only work, for example wanting to use SSIS to wrap SQL statements outside of a programming language.
(5 stars) - perfect addition to BOL
there is a lot of advanced features of SSIS that I needed to learn, that BOL and Google seraches were not helping with. This book was a great help.
It is advanced, and not meant to be your primary resource or used for learning SSIS.
Popular Searches in Books compact disk love, book laser, significado de los suenos, skeleton key book anthony horowitz, manga comic books, medical assistant books, soft animal baby book, como hacer el amor, significado de los nombres, incest, greatest political science books, books, one minute monologues monologues for teens, fotos playboy, dragon books, harcourt math books, playboy fotos, book laser, met art, solutions manual, More |
