Microsoft SQL Server 2005 Integration Services 进阶指南

出版时间：2007-6  出版社：Microsoft Pr  作者：Turley, Paul/ Kasprzak, Joe/ Cameron, Scott/ Iizuka, Satoshi/ Guzman, Pablo  页数：453  

内容概要

Integration Services is a powerful tool for business intelligence, so understanding the essentialshow to develop and deploy SSIS packages, as well as how to apply these skills to data warehousing solutionsis critical to harnessing the full benefits of SQL Server. This step-by-step tutorial teaches you all the essentials for getting started, including data transformation, scripting, security, and best practices for developing enterprise-class data integration applications. With Step By Step, you work at your own pace through hands-on, learn-by-doing exercises. Whether youre a beginning programmer or new to this version of the technology, youll understand the fundamental techniques for using SQL Server 2005 Integration Services. A companion CD includes data sets and sample code.

书籍目录

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