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.
To get the free app, enter your email address or mobile phone number.
Beginners Guide to SQL Server Integration Services Using Visual Studio 2005
Use the Amazon App to scan ISBNs and compare prices.
Customers Who Viewed This Item Also Viewed
More About the Author
Top Customer Reviews
I was excited to get this book in the mail, as I know how difficult it is to find a good beginners guide for SSIS. I'm no longer a newbie, but I once was and I found that the good books were almost too advanced and too comprehensive to get some simple tasks done and to get a good understanding of the tool and involved concepts.
Unfortunately, I found this book difficult to read. I also found that it contained many technical inaccuracies. The author (a non-native English speaker I assume) struggles to get good, succinct points across. I am not saying that a total beginner could not get into this book and get a few packages developed, but for Data Warehousing professionals, DBAs, and developers, this is not the book to keep in your reference library.
For example, on page 123, the author writes:
"The Bulk Insert Task cannot be used with any of the data flow transformation components, and in this respect is not as versatile as a data flow task. This task has been provided for backward compatibility."
Hmmn... First of all, it would be nice to know why the Bulk Insert Task cannot be used with any of the transforms (short answer: The Bulk Insert Task is a Control Flow item). It would also be very helpful to the reader to have an idea why you would select a Bulk Insert over a Data Flow. Lastly, the Bulk Insert Task is *not* provided for backward compatibility!Read more ›
Packt asked me to review this book, and their timing was perfect--I was ready to start an SSIS project but had no experience. I was a heavy DTS user, and the difference between DTS and SSIS blew my mind. The first two chapters are a reference of the different flows, transformations, sources and destinations available, and the rest of the book is essentially a workbook, full of how-to examples for very common tasks. Even if what you need to do isn't covered,
I did hope there would be a section on the new "fuzzy" objects, but there was none. This book also does not discuss way to organize your solutions and projects, but this also was left to more advanced books.
I've loaned this book to several coworkers, and all have found it useful. We all came up to a basic understanding of SSIS very quickly, and have a good enough understanding to pick up more advanced examples.
On my last round of book purchases I picked up Jayaram's "Beginners Guide to SQL...", this is BY FAR the BEST book I have purchased on SSIS! I have actually been able to walk through each one of the examples in the book to gain better understanding of how SQL SSIS works. The books has a lot of excellent screenprints (they do not have figure numbers, but they follow they text and I wasn't confused without the numbers).
The writing style of the book was really straight forward and to the point step-by-step directions, so that you can follow along with a sample database.
Please note in the title of this book it says 'for beginners', so some of the more advanced topics may not be in this book, but it definitely sets you up to have a basic concept and then you can move on. This book allowed me to be able to open the other books I have purchased (and gave me a clue what they were saying).
I would recommend purchasing this book if you are new to SSIS and would like to have a textbook style reference that you can refer back to see how to setup the different SSIS concepts.
The book is written in learning stages: each part of the SSIS application along with its Visual Studio 2005 counterpart for application development is discussed. These functions are then tested to an actual application. Actual screenshots are used to give the developers an idea on how the application development progresses.
But not everything is presented at once. In the early chapters of the book, developers will first learn the basics on software development using SSIS and Visual Studio 2005. The actual use of the software development tool is presented later.
These basics are enough for the build a simple application. Once the basics are covered an exercise is presented so that developers can immediately apply what they have learned. As the chapters progresses, advanced functions and skills are presented. It is again presented through a series of screen shots so that developers could understand how it is done. Once enough information has been presented, another battery of tests so that skills will be used in the actual scenario.
If you are looking for a good book to start developing SSIS with Visual Studio 2005, this book provides a great start. This book could easily become a good reference book as the skills of the developer progresses in SSIS and Visual Studio.
Most Recent Customer Reviews
First of all, the author's written English is not good. If people say you own
language at home, it is fine. Read more
I come from DTS (SQL server 2000) got very frustrated with SSIS. DTS packages I use to write "with my eyes closed" became nightmare adventures in SSIS I purchased a $300 online... Read morePublished on April 16, 2010 by Cool_Sam
This book is an Excellent book on SSIS. I have been looking for a book like this where I can find real life examples. Read morePublished on October 5, 2009 by S. Rahman
This is the first time I have ever given a book 1 star, but if there is ever a book to deserve it, this is the one. This is, by far, the worst technical book ever written. Read morePublished on April 14, 2009 by Barry Turney
This book was written by authors who appear to have English as a second language. The editing is poor and the text is full of grammatical errors that are distracting (at best) and... Read morePublished on February 28, 2009 by Matthew J. Briggs
I was a moderately capable DTS user and felt like MS jerked the rug out from under me with SSIS. Who needs all these windows and properties? Not me. Read morePublished on January 31, 2009 by M. Hoyt
The book is pretty basic and easy to understand for creating and executing packages, but does not cover the deployment of packages. Read morePublished on July 30, 2008 by A Squared
This book was worth the money for me. While I am familiar with DTS and SSIS, I've never used them and therefore had no experience for getting started. Read morePublished on June 2, 2008 by Levi Hops