Microsoft® SQL Server™ 2008 Integration Services unleashed

Microsoft? SQL Server? 2008 Integration Services unleashed SAMS 文字版 Contents at a Glance Foreword . . . . . . . . . . . . . . . . . . . . . . . . . xx Part I Getting Started 1 What Is Integration Services and Why Do I Need It?................3 2 Setting Up Integration Services ...................9 3 What’s New in Integration Services 2008 ......................21 4 Migrating to Integration Services 2008 ...............27 Part II Integration Services Basics 5 The Business Intelligence Development Studio ..................41 6 The Building Blocks of Integration Services...................89 7 Grouping Control Flow with Containers............99 8 Building a Package—Quick Start ..................119 Part III Control Flow Services 9 The Venerable Variable .......................137 10 Using Expressions ..........................151 11 The Stock Tasks and Connection Managers......................169 12 Using the Script Task ..........................259 13 Using the Data Profiling Task ..................279 14 Logging and the Stock Log Providers ................295 15 Looping and Foreach Enumerators ...................313 Part IV Management Services 16 SQL Server Management Studio ...................337 17 Using Source Control..........................351 18 Securing Packages...........................361 Part V The Data Flow Task 19 Introducing the Data Flow Task ...................377 20 The Stock Data Flow Components ...............385 21 Using the Script Component...................445 22 Advanced Data Flow Transformations ..............463 23 Data Flow Task Internals and Tuning................499 Part VI Solving Common Challenges 24 Configuring and Deploying Solutions ..............525 25 Common Challenges ..........................557 Part VII Advanced Package Concepts and Patterns 26 Troubleshooting Packages........................575 27 Building Advanced Packages ...................589 Part VIII Programming Integration Services 28 Building Custom Tasks .......................607 29 Building Custom Data Flow Components ...................665 Index . . . . .. . . . .. . . . .. . . . .. . . . . . 705