Professional Microsoft SQL Server 2011 Integration Services

Provides advice on using the latest version of the software for performing extraction, transformation, and load operations, along with information on best practices developed since the previous update.

List of contents

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

Product details

• Authors: Mike Davis, Bria Knight, Brian Knight, Jessica Moss, Jessica M et al Moss, Jessica M. Moss, Chris Rock, Eri Veerman, Erik Veerman
• Publisher: Wiley, John and Sons Ltd
• Languages: English
• Product format: Paperback / Softback
• Released: 29.02.2012
• EAN: 9781118101124
• ISBN: 978-1-118-10112-4
• No. of pages: 960
• Dimensions: 190 mm x 236 mm x 46 mm
• Subject: Natural sciences, medicine, IT, technology > IT, data processing