| New Releases | | • | Master Data Management (The MK/OMG Press) | | • | DW 2.0: The Architecture for the Next Generation of Data Warehousing (Morgan Kaufman Series in Data Management Systems) | | • | Refactoring SQL Applications | | • | Agile Data Warehousing: Delivering World-Class Business Intelligence Systems Using Scrum and XP | | • | Improving Business Intelligence: The Six Sigma Way | | • | Data Warehouse 100 Success Secrets - 100 most Asked questions on Data Warehouse Design, Projects, Business Intelligence, Architecture, Software and Models | | • | Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications (Data-Centric Systems and Applications) | | • | Algorithms and Architectures for Parallel Processing: 8th International Conference, ICA3PP 2008, Agia Napa, Cyprus, June 9-11, 2008, Proceedings (Lecture Notes in Computer Science) | | • | Encyclopedia of Data Warehousing and Mining, Second Edition | | • | Data Warehousing and Knowledge Discovery: 10th International Conference, DaWak 2008 Turin, Italy, September 1-5, 2008, Proceedings (Lecture Notes in Computer Science) |
|
|
|
|
Expert SQL Server 2005 Integration Services (Programmer to Programmer) | 
 enlarge | Authors: Brian Knight, Erik Veerman
Publisher: Wrox
Category: Book
List Price: $49.99
Buy New: $13.28
You Save: $36.71 (73%)
New (42) Used (12) from $13.28
Avg. Customer Rating:  13 reviews
Sales Rank: 34285
Media: Paperback
Number Of Items: 1
Pages: 432
Shipping Weight (lbs): 1.3
Dimensions (in): 9.1 x 7.4 x 1
ISBN: 0470134119
Dewey Decimal Number: 005.7585
EAN: 9780470134115
ASIN: 0470134119
Publication Date: May 29, 2007
Availability: Usually ships in 1-2 business days
Shipping: Expedited shipping available
Shipping: International shipping available
Condition: SHIPS TODAY!!!!!! BRAND NEW BOOK
|
| Editorial Reviews:
Product Description
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.
|
| Customer Reviews: Read 8 more reviews...
 Forged from developing production ETL systems August 27, 2008
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.
 Misleading title. Might be good for BI+OLAP work, but lousy as a generalist reference. July 28, 2008
1 out of 2 found this review helpful
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.
 perfect addition to BOL May 28, 2008
0 out of 1 found this review helpful
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.
 Don't try the samples April 18, 2008
1 out of 1 found this review helpful
There are lots of 5-star books with great content, but with poor samples. Unfortunately, this is one of those books.
Did anybody try the samples of Chapter 3? The sample of Figure 3-26 returns many records back (not empty as shown in the book), maybe because there is millisecond in the modified date field; the sample of Figure 3-27 does not work at all, because SSIS complains the value of timestamp field can not be assigned to that variable; the sample of figure 3-32 has no required flat file available in the downloaded zip file ...
There are solutions to fix them, of course. But, the samples do not work really annoyed me.
Definitely for experts April 11, 2008
3 out of 3 found this review helpful
I tried to dive right into this book as my first exposure to SSIS 2005. I hate combing through tons of beginner stuff. Well, it was definitely for experts. I only made it through 3 chapters and gave up. I purchased the Proffessional companion title to this and got a much better foundation. This Expert book has helped me extend my knowledge of what I learned in the Professional book and perform some really cool automation in my projects.
I do not recommend this as your first exposure. Get the Professional SQL Server 2005 Integration Services book first.
|
|
|
Powered by Associate-O-Matic
| |
