Microsoft SQL Server 2005 Integration Services 进阶指南

书籍目录

Part 1 Started with Integration Services Getting　1　Introduction to SQL Server Integration Services　2　Building Your First PackagePart II Designing Packages　3　Extracting and Loading Data　4　Using Data Flow Transformations　5　Managing Control Flow　6　Scripting Tasks　7　Debugging Packages　8　Managing Package ExecutionPart III Managing Packages　9　Detecting and Handling Processing Errors  10　Securing and Deploying SSIS Packages  11  Optimizing SSIS PackagesPart IV Applying SSlS to Data Warehousing  12　Data Warehouse Concepts  13　Populating Data Warehouse Structures  14　SSIS General Principles

作者简介

在线阅读本书



Teach yourself the fundamentals of SQL Server Integration Servicesone step at a time. This practical, learn-by-doing tutorial delivers the guidance you need to transform and consolidate dataand build solutions that support your business intelligence needs. Discover how to: Design and execute packages that transform data between files and relational databases Configure connection managers to access other data sources Create data flows that alter, split, match, and merge data Develop event-handlers and monitor package performance Encrypt sensitive information and control access to packages Customize script code to automate Control Flow and Data Flow tasks Debug, troubleshoot, and optimize packages CD features: All practice exercises Sample databases Fully searchable eBook

 Microsoft SQL Server 2005 Integration Services 进阶指南下载