- ホーム
- > 洋書
- > 英文書
- > Computer / Databases
Full Description
Publisher's Noteguaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Transform Raw Data Into Meaningful Business Intelligence with SSISDeploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource.Build SSIS packages using the Import and Export Wizard and Business Intelligence Development StudioCreate Loop and Task Host Containers with Control Flow DesignerAdminister SSIS from SQL Server Management Studio and dutilSecure packages using encryption, roles, signatures, and permissionsBuild-in memory lookups and transformations using the Data Flow EngineExtend functionality using custom scripts and ActiveX componentsUse SCD transformations to load data warehouses and data martsLearn to build a Star Schema and Parallel Data WarehouseMigrate Data Transformation Services 2000 and SSIS 2005 packages
Contents
Chapter 1 Introducing SQL Server Integration ServicesChapter 2 Getting Started With WizardsChapter 3 Nuts and Bolts of the SSIS WorkflowChapter 4 Integration Services Control Flow ContainersChapter 5 Integration Services Control Flow TasksChapter 6 Administrating Integration ServicesChapter 7 Securing Integration Services PackagesChapter 8 Advanced Features of Integration ServicesChapter 9 Data Flow ComponentsChapter 10 Data Flow TransformationsChapter 11 Programming Integration ServicesChapter 12 Data Warehousing and SQL Server 2008 EnhancementsChapter 13 Deploying Integration Services PackagesChapter 14 Migrating to Integration Services 2008Chapter 15 Troubleshooting and Performance EnhancementsAppendix How to Use the Provided SoftwareNER(01): WOW
