- Paperback: 432 pages
- Publisher: Wrox; 1 edition (May 29, 2007)
- Language: English
- ISBN-10: 0470134119
- ISBN-13: 978-0470134115
- Product Dimensions: 7.4 x 1 x 9.2 inches
- Shipping Weight: 1.3 pounds (View shipping rates and policies)
- Average Customer Review: 16 customer reviews
- Amazon Best Sellers Rank: #727,129 in Books (See Top 100 in Books)
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 mobile phone number.
Expert SQL Server 2005 Integration Services 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
From the Back Cover
Developing data processing extraction, transformation, and loading (ETL) solutions is now easier than ever with this practical guide. It shows you how to apply the components of SQL Server 2005 Integration Services (SSIS) to build an enterprise ETL application that scales and performs to your specifications. You'll not only learn how to design and implement the necessary architecture, you'll also find out how to utilize the proper administration techniques.
Written by two SQL Server MVPs, this book first provides you with all the background and foundation information you'll need on scripting and data extraction. It then takes you through the details of data warehousing ETL, error handling, administration, and data integration. By following this approach, you'll quickly discover how to take advantage of SSIS functionality to meet your data integration and processing requirements.
What you will learn from this book
- Powerful uses of scripting to develop more advanced applications
All about the relational database transformation and loading methods for dimension and fact tables
Steps for creating sophisticated solutions that easily handle processing errors
Best practices for moving between your support and production environments
Tips for leveraging SSIS features that make your migrated packages better
How to design and tune your packages to achieve the most scalability
Who this book is for
This book is for experienced SQL Server database developers, architects, and administrators who want to build ETL applications using SSIS.
Wrox Expert books present the wisdom accumulated by an experienced author team who is recognized as experts by the programming community. These experts challenge professional developers to examine their current practices in pursuit of better results.
Enhance Your Knowledge
Advance Your Career
About the Author
Brian Knight (SQL Server MVP, MCSE, MCDBA) of Green Cove Springs, Florida, is the co-founder of SQLServerCentral.com and JumpstartTV.com. He runs the local SQL Server users group in Jacksonville (JSSUG) and was on the Board of Directors of the Professional Association for SQL Server (PASS). He is a contributing columnist for SQL Server Standard and also maintains a regular column for the database web site, SQLServerCentral.com, as well as doing regular webcasts at JumpstartTV.com. He has co-authored and authored more than nine SQL Server books, including Admin911: SQL Server 2000 (McGraw-Hill Companies, 2001), Professional SQL Server 2000 DTS (Wiley Publishing, 2000), Professional SQL Server 2005 Administration (Wiley Publishing, 2006), and Professional SQL Server 2005 Integration Services (Wiley Publishing, 2006). He has spoken at conferences such as PASS, SQL Connections, and TechEd, as well as at many Code Camps. His blog can be found at www.whiteknighttechnology.com. He is an independent consultant at Pragmatic Works and spends most of his time trying to think about how to use the word onomatopoeia in everyday sentences.
Erik Veerman (SQL Server MVP, MCT, MCDBA) is a Mentor for Solid Quality Learning focusing on training, mentoring, and architecting solutions on the SQL Server Business Intelligence (BI) platform. His industry recognition includes Microsoft’s Worldwide BI Solution of the Year and SQL Server Magazine’s Innovator Cup winner. He has designed dozens of BI solutions across a broad business spectrum—telecommunications, marketing, retail, commercial real estate, finance, supply chain, and information technology. His experience with high-volume, multi-terabyte environments and SQL Server 64-bit has enabled clients to scale their Microsoft-based BI solutions for optimal potential. As an expert in OLAP design, ETL processing, and dimensional modeling, he is a presenter, author, and instructor. He led the ETL architecture and design for the first production implementation of SQL Server Integration Services (SSIS) and helped drive the ETL standards and best practices for SSIS on Microsoft’s SQL Server 2005 reference initiative (Project REAL). He also co-authored Professional SQL Server 2005 Integration Services (Wiley Publishing, 2006). As a resident of Atlanta, Georgia, Erik is a leader of the local Atlanta SQL Server User’s Group, a PASS and INETA user group chapter.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
Highly recommended this book as I can usually find myself highly recommending a lot of the WROX material.
I do not recommend this as your first exposure. Get the Professional SQL Server 2005 Integration Services book first.
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.
It is advanced, and not meant to be your primary resource or used for learning SSIS.
Now I understand that it is pretty difficult to write a book that covers what is useful specifically to me, so the book has to generalize and try to cover topics that are needed to most. However, I have to question many of the tasks that were chosen. If you are already familiar with .NET class programming, and I have to presume that most people wanting to program SSIS already are, you can pretty much completely skip Chapter two. As another example, the first half of chapter three covers data sources, and you can get the same information in the standard help files.
Now the book is not a complete throwaway, as there are some worthwhile examples and discussions, albeit most of them are not as detailed or thorough as I would have expected. If you can purchase the book up for under $15, it might be worth picking up. Overall, though, I would have a hard time recommending it and would find it very hard to believe that anybody would think that this book was hard to do without.
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?
"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 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.
Most recent customer reviews
Did anybody try the samples of Chapter 3?Read more