- 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: #2,130,790 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.
Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.
If you're a seller, Fulfillment by Amazon can help you increase your sales. We invite you to learn more about Fulfillment by Amazon .
Customers who viewed this item also viewed
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.
It is advanced, and not meant to be your primary resource or used for learning SSIS.
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.
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.
Most recent customer reviews
Did anybody try the samples of Chapter 3?Read more