|
| 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: $15.97
You Save: $34.02 (68%)
New (38) Used (9) from $15.97
Avg. Customer Rating:  14 reviews
Sales Rank: 42570
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
Shipping: Eligible for Super Saver Shipping
Availability: Usually ships in 24 hours
|
| 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 9 more reviews...
 Good example and material October 27, 2008
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.
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
4 out of 5 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
1 out of 2 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.
|
|
|
| | New Releases | | • | Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications (Data-Centric Systems and Applications) | | • | Master Data Management (The MK/OMG Press) | | • | Netezza Underground: The unauthorized tales of derring-do and adventures in resilient data warehousing solutions. | | • | SQL in a Nutshell (In a Nutshell (O'Reilly)) | | • | Master Data Management | | • | Data Warehouse 100 Success Secrets - 100 most Asked questions on Data Warehouse Design, Projects, Business Intelligence, Architecture, Software and Mo | | • | The Data Model Resource Book: Universal Patterns for Data Modeling | | • | Database Archiving: How to Keep Lots of Data for a Very Long Time (The MK/OMG Press) (The MK/OMG Press) | | • | Information Systems Security: 4th International Conference, ICISS 2008, Hyderabad, India, December 16-20, 2008, Proceedings | | • | New Trends in Data Warehousing and Data Analysis (Annals of Information Systems) |
|
|
|
|
