| | |  | Software Design, Testing & Engineering | Home » » » Professional SQL Server 2005 Integration Services (Programmer to Programmer) | | | | | | | Description: | | This book will help you get past the initial learning curve quickly so that you can get started using SSIS to transform data, create a workflow, or maintain your SQL Server. Offering you hands-on guidance, you'll learn a new world of integration possibilities and be able to move away from scripting complex logic to programming tasks using a full-featured language.What you will learn from this book - Ways to quickly move and transform data
- How to configure every aspect of SSIS
- How to interface SSIS with web services and XML
- Techniques to scale the SSIS and make it more reliable
- How to migrate DTS packages to SSIS
- How to create your own custom tasks and user interfaces
- How to create an application that interfaces with SSIS to manage the environment
- A detailed usable case study for a complete ETL solution
Who this book is for This book is for developers, DBAs, and users who are looking to program custom code in all of the .NET languages. It is expected that you know the basics of how to query the SQL Server and have some fundamental programming skills. Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job. | | | Product Details: | | | Author:
| Brian Knight | | Paperback:
| 720 pages | | Publisher:
| Wrox | | Publication Date:
| January 31, 2006 | | Language:
| English | | ISBN:
| 0764584359 | | Product Length:
| 9.2 inches | | Product Width:
| 7.46 inches | | Product Height:
| 1.57 inches | | Product Weight:
| 2.31 pounds | | Package Length:
| 9.0 inches | | Package Width:
| 7.3 inches | | Package Height:
| 1.6 inches | | Package Weight:
| 1.3 pounds | | Average Customer Rating:
|  based on 34 reviews |
| | | | Customer Reviews: | |
Average Customer Review:
 ( 34 customer reviews )
Write an online review and share your thoughts with other customers.
Most Helpful Customer Reviews
106 of 108 found the following review helpful:
 Hang on a sec.... have any of the reviewers ACTUALLY READ this book??Mar 11, 2006
By ACD
While I share the enthusiasm of the other reviewers, I'm not entirely convinced that any of them have read far enough to give the book 5 stars. I have nearly 10 years under my belt in BI, worked with SQL Server extensively, and not too shabby in the .NET department either; to be certain, SSIS 2005 is truly groundbreaking. However, the watchful readers will find a hurried book in their hands, one numerous typos and misleading information. For example, while I was able to figure out the nature of the strongly-typed properties of the incoming Row object for the Script Component example (Chapter 7) (you need to define the "Cleaned" ones yourself in the Script Transformation Editor to support the code for your Script Component), the book isn't completely clear and such information may not be so apparent to those new to the SSIS (or ETL) experience. Donald Farmer's book covering SSIS 2005 Scripting (the beta version) covers the Script Task and Script Component Transform Task better than Professional SQL Server 2005 Integration Services. Whilst I have focused on Chapter 7, I have found this pattern throughout the book. To be clear, I'm not terribly displeased with this book... it provides just enough coverage of the new product to get you going (with a welcome "under the hood" look at the SSIS engine) it's just that a 2nd Edition is required from WROX/WILEY to clean up its somewhat misleading content.
41 of 43 found the following review helpful:
 Pick another book!Jun 24, 2007
By Pen Name
***NOTE TO WROX*** Before you release a tutorial, have someone other than the authors (or their friends) try each and every lesson!
This has to be one of the WORST tutorial/step-by-step books ever written.
I'm a seasoned DBA that has worked on every version of MS-SQL ever released. Starting with 4.9.2. I've also worked on Sybase, Oracle, Postgress and MySQL. Add to this several years of VB/C experience and time spent as a corporate trainer, and you can guess my technical aptitude. My experience with DTS/ETL includes hundreds (if not thousands) of packages on 7.0 & 2000. This book was purchased as a means of ramping up for a new consulting gig on SSIS. It was a complete waste of money.
The "tutorials" are disorganized, confusing, and the instructions don't match the examples. Even more annoying are the sections that appear to be lessons that aren't. You won't realize this until you start inputting the example and then get to a new paragraph that tells you this subject will be covered in another chapter. Even worse are the real examples whose instructions refer you back to a step that was left out or edited out of the book. This begins in chapter two when you are told to create a new "project" and then later told to add another project to the "solution", but, there was never any mention on how to start a "solution". This sets the tone for the rest of the book. You'll learn early on to read the entire chapter, then go back to the beginning and "try" the examples. Don't even get me started on the explanations being on one page, while the diagrams for the explanation are on the back of that page. Read a few sentences; turn the page to see the diagram; turn back to read some more; turn back to see the diagram (lather, rinse, repeat...)
It normally takes me only a few hours to breeze through five or six chapters of a technical tutorial. After TWO DAYS (a full Saturday and Sunday) of frustration that got me as far as half way through the fourth chapter, I discarded the book, drove to a local bookstore and bought something else off the self.
Rule #1 for tutorial books: The instructions must be COMPLETE.
Rule #2: The instructions must be in the order necessary to complete the lesson, (ie. 1-2-3-4, not, 1-4-3-5, oops...did we forget or edit out a step?)
29 of 30 found the following review helpful:
 Okay, but a little bit disappointing tooJul 25, 2006
By Carsten Cumbrowski
"Carsten aka Roy/SAC & CirqueDuSoleilGuru"
I bought this book and had a lot of expectations. 10 Writers were involved to write this book which covers a complete new software tool from Microsoft, introduced with the newly released SQL Server 2005 replacing the DTS Service of SQL Server 2000 and earlier Versions plus adding tons of new features to the enterprise Database Solution which were previously unavailable.
The fact that 10 people contributed to it can be felt throughout the book, because no or little efforts were made to keep the writing style consistent. That can be a bit confusing at times.
Also when it comes to the content, are a lot of things not covert at all or not very well. When I did seek the help from the book for the first time for a very specific problem I tried to solve with SSIS, did the book fail to provide the answers to me. It addressed the problem, but it only addressed the stuff I already figured out myself. To the item I had my problem with did only exist a side note which did not help me at all. That was already a bad start.
I am looking for better alternatives which I have not found yet. It is probably good for somebody who wants to get an overview or general idea of the new Service, but might be the wrong choice for somebody who has specific applications in mind and tries to find answers to problems in this book.
16 of 18 found the following review helpful:
A good starting PointMar 23, 2006
By Aftab Chopra
"Aftab Chopra"
The book provides a good starting point to learn SSIS, especially if you never worked with DTS.
However the book does give you a feeling that it was hurried, and the case study really does not adress the challenges you will face in real projects.
But for the Novice, this is a great book to get started with Integration Services.
12 of 13 found the following review helpful:
Still trying to find a decent book on SSISApr 11, 2007
By Just me
"Bill"
I wish I could say that this book is the definitive book on SSIS, but I can't. The majority of the content seems to be nothing more than a reiteration of exactly what's in BOL and we all know how helpfull that can be.
I have tried several times to find information in this book that would help me get past a hurdle that I was having with SSIS and couldn't seem to get a good answer. Most of the explanations where thin and just glossed over the information. For instance, with Web Services being so hugely important these days, you think they would have spent more than about three pages discussing them. Their example was very simple and either SSIS is just not capable of being more robust in this area, or the authors didn't feel it was important enough.
I would rather have had them get authors who actually had expertise in each topic and right a detailed chapter on each feature. It would have been much more preferable to this book which tries to cover everything, but just doesn't give enough info to be of use. At least it wasn't to me.
Wrox used to stand for knowledge - each book I have gotten from them within the last two years has continued to dissappoint me.
As a good overview of what SSIS is, I think this book succeeds. As being a weighty tome of information, keep looking, you won't find it here. :(
See all 34 customer reviews on Amazon.com
| | |
|
