Beschreibung:
Brian Knight is the founder of Pragmatic Works and co-founder of SQLServerCentral.com and JumpstartTV.com.
Erik Veerman is a consultant, author, trainer, and a mentor with SolidQ. His award-winning industry recognition includes Microsoft's BI Solution of the Year and SQL Server Magazine's Innovator Cup.
Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server business intelligence who has created data warehousing solutions for a variety of industries.
Mike Davis, MCTS, MCITP, is the Managing Project Lead at Pragmatic Works. He has co-authored several business intelligence books and regularly speaks at SQL events.
Chris Rock is a software developer and program manager at Pragmatic Works, where he develops custom SSIS components and software.
INTRODUCTION xxix
CHAPTER 1: WELCOME TO SQL SERVER INTEGRATION SERVICES 1
CHAPTER 2: THE SSIS TOOLS 17
CHAPTER 3: SSIS TASKS 39
CHAPTER 4: CONTAINERS 93
CHAPTER 5: THE DATA FLOW 105
CHAPTER 6: USING VARIABLES, PARAMETERS, AND EXPRESSIONS 161
CHAPTER 7: JOINING DATA 201
CHAPTER 8: CREATING AN END-TO-END PACKAGE 233
CHAPTER 9: SCRIPTING IN SSIS 253
CHAPTER 10: LOADING A DATA WAREHOUSE 313
CHAPTER 11: ADVANCED DATA CLEANSING IN SSIS 353
CHAPTER 12: USING THE RELATIONAL ENGINE 375
CHAPTER 13: ACCESSING HETEROGENEOUS DATA 413
CHAPTER 14: RELIABILITY AND SCALABILITY 453
CHAPTER 15: UNDERSTANDING AND TUNING THE DATA FLOW ENGINE 487
CHAPTER 16: SSIS SOFTWARE DEVELOPMENT LIFE CYCLE 521
CHAPTER 17: ERROR AND EVENT HANDLING 549
CHAPTER 18: PROGRAMMING AND EXTENDING SSIS 585
CHAPTER 19: ADDING A USER INTERFACE TO YOUR COMPONENT 643
CHAPTER 20: EXTERNAL MANAGEMENT AND WMI TASK IMPLEMENTATION 669
CHAPTER 21: USING SSIS WITH EXTERNAL APPLICATIONS 719
CHAPTER 22: ADMINISTERING SSIS 743
CHAPTER 23: CASE STUDY: A PROGRAMMATIC EXAMPLE 797
INDEX 883
Lieferung vom Verlag mit leichten Qualitätsmängeln möglich
An in-depth look at the radical changes to the newest release of SISS
Microsoft SQL Server 2012 Integration Services (SISS) builds on the revolutionary database product suite first introduced in 2005. With this crucial resource, you will explore how this newest release serves as a powerful tool for performing extraction, transformation, and load operations (ETL). A team of SQL Server experts deciphers this complex topic and provides detailed coverage of the new features of the 2012 product release. In addition to technical updates and additions, the authors present you with a new set of SISS best practices, based on years of real-world experience that have transpired since the previous edition was published.
Details the newest features of the 2012 SISS product release, which is the most significant release since 2005
Addresses the keys to a successful ETL solution, such as using the right enterprise ETL tool and employing the right ETL architecture in order to meet the system requirements
Includes additional case studies and tutorial examples to illustrate advanced concepts and techniques
Professional Microsoft SQL Server 2012 Integration Services is a valuable resource that meets the demands and high expectations of experienced SSIS professionals.