Expert SQL Server 2005 Integration Services 1st Edition
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.
From the Back Cover
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
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.
- Item Weight : 1.43 pounds
- Paperback : 432 pages
- ISBN-10 : 0470134119
- ISBN-13 : 978-0470134115
- Dimensions : 7.4 x 1 x 9.2 inches
- Publisher : Wrox; 1st edition (May 29, 2007)
- Language: : English
- Best Sellers Rank: #5,637,508 in Books (See Top 100 in Books)
- Customer Reviews:
Top reviews from the United States
There was a problem filtering reviews right now. Please try again later.
I do not recommend this as your first exposure. Get the Professional SQL Server 2005 Integration Services book first.
Highly recommended this book as I can usually find myself highly recommending a lot of the WROX material.
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.