 |
Expert SQL Server 2005 Integration Services
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: - Professional SQL Server 2005 Integration Services; Brian Knight, et al, $30.95, 38% Off!
- Professional SQL Server 2005 CLR Programming with Stored Procedures, Functions, and Triggers; Derek Comingore, et al, $30.50, 39% Off!
- Inside Microsoft SQL Server 2005: Query Tuning and Optimization (Stock Expected October 7th); Kalen Delaney, $30.95, 38% Off!
- Professional SQL Server 2005 Reporting Services; Paul Turley, et al, $24.95, 38% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
As a practical guide for Integration Services ETL development, this book shows
you ways to implement your ETL solution requirements from the data to the administration
and everything in-between. Each chapter begins with a review of pertinent ETL
concepts and moves into working those out into a design with multiple examples
and related Integration Services features with the end goal of putting it all
together to get a solution.
Table of Contents
Acknowledgments.
Introduction.
Chapter 1: Getting Started.
Chapter 2: Extending Scripts in SSIS.
Chapter 3: Data Extraction.
Chapter 4: Dimension ETL with SSIS.
Chapter 5: Fact Table ETL.
Chapter 6: Processing Analysis Services Objects with SSIS.
Chapter 7: Package Reliability.
Chapter 8: Deployment.
Chapter 9: Managing SSIS.
Chapter 10: Handling Heterogeneous and Unusual Data.
Chapter 11: Migrating from DTS to SSIS.
Chapter 12: Scaling SSIS.
Index.
About the Authors
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.
More By These Authors
|
|
