Microsoft SQL Server 2008 Integration Services Problem-design-solution
What other items do customers buy after viewing this item?
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
Build practical SSIS solutions to real–world problems
SQL Server Integration Services (SSIS) is the most widely adopted Business Intelligence (BI) component of SQL Server and the leading extraction, transformation, and loading (ETL) tool in the data warehouse industry. Written by a team of Microsoft MVPs for SQL Server, this book presents you with an array of common problems that SSIS administrators and developers face on a daily basis, and walks you through the steps necessary to solve these challenges.
Demonstrates how to solve common pitfalls involved with SSIS deployment
Shares solutions for challenges you may encounter with package deployment and storage decisions
Explores file handling and processing methods
Reviews best practices for data extraction
Covers the basic concepts and challenges of dimension table ETL and fact table ETL
Solves problems that may arise with scripting design patterns and SSIS package scaling
Discusses how to effectively scale and performance–tune SSIS packages
Wrox Problem Design Solution references give you solid, workable solutions to real–world development problems. Each chapter is devoted to a different scenario, analyzing every problem, examining relevant design issues, and implementing the ideal solution.
Join our Programmer to Programmer forums to ask and answer programming questions about this book, join discussions on the hottest topics in the industry, and connect with fellow programmers from around the world.
Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use.
Find articles, ebooks, sample chapters and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.
About the Author
Erik Veerman is a Microsoft MVP for SQL Server and a mentor for Solid Quality Mentors. He is a coauthor of Professional SQL Server 2008/2005 Integration Services with Brian Knight.
Jessica M. Moss is a Microsoft MVP in SQL Server and a BI mentor, consultant, and trainer with Solid Quality Mentors.
Brian Knight is a Microsoft MVP For SQL Server and the cofounder of SQLServerCentral.com and JumpstartTV.com.
Jay Hackney is a mentor and consultant for Solid Quality Mentors, who works with SSIS to provide data warehousing and ETL solutions.--This text refers to the Paperback edition.
Top Customer Reviews
The book contains some excellent info, however I found during the hands-on parts, many of the steps that needed to be followed were buried in the main text and were therefore easy to miss.
Would (for my tiny brain) prefer numbered steps for these parts.
Most Helpful Customer Reviews on Amazon.com (beta) (May include reviews from Early Reviewer Rewards Program)
I can do anything needed in SSIS (control flow and data flow), but this book made me realize a major shortcoming in my general approach and the approach of the company I worked at. We treated each SSIS implementation as a separate, unique project. Each SSIS package had it's own configuration setup, non-shared logging and auditing schemes and none of it was scalable. This resulted in a mish-mash of styles in our hundreds of SSIS packages throughout the company.
If you have any experience with SQL Server and SSIS, this book can be used as a great roadmap for creating an overall architecture for SSIS implementations. The best time to impose this roadmap is prior to creating any SSIS packages, there are advisories to this effect in the book. Due to my prior experience above, I can tell you they are exactly right in saying that. If you already have a few SSIS packages built, (what's a few? <20?), it wouldn't be a huge effort to go back and retrofit the existing packages into the recommended architecture.
I've been angling for a consulting job that requires SQL Server and more importantly, SSIS experience. The customer is changing over from an ETL layer that is T-SQL code-heavy to one that is going to be SSIS-heavy. When I interview, the concepts in this book are going to get me that job.
I initially put off buying this book for a week because it only had one review at the time (even though it was 5 stars).
This is an excellent Book!
Simply put, should I write code or architect a process flow (package) with minimum code effort to solve business problem? If architecting is a choice then this book is for you.
The book covers package framework, design and development. It walks you through design patterns for developing effective SSIS packages. There is a nice section on package's performance with comparison to memory and disk I/O bottlenecks.
The book also covers physical infrastructure and deployment by focusing on package deployment on single/multiple computers and talk about processor capacity, RAM and physical disk size.
Very well structured and written.
I still have it around and have recommended it to several friends.