书名: Microsoft® SQL Server™ 2005 Integration Services Step by Step
作者: Paul Turley (Author), Hitachi Consulting (Author)
页数: 480 pages
出版: Microsoft Press; Pap/Cdr edition (June 20, 2007)
语言: English
ISBN-10: 0735624054
ISBN-13: 978-0735624054
http://www.microsoft.com/MSPress/books/10930.aspx
《SQL Server 2005集成服务指导手册》共分14章，以SQL Server2005的管理、应用为核心，从了解数据库在网站中的重要性和认识SQL Server2005入手，全面介绍了SQL Server2005的安装、配置、结构化查询语言、数据库和表的管理、数据备份与恢复、数据安全管理、XML支持、数据库报表服务、数据库常用管理工具、网站数据库访问、网站数据库应用实例等内容。从内容上紧扣SQL Server2005的新特性、新功能、新技术，以详尽的实例，深入浅出地介绍了SQL Server2005在数据库管理和网站应用方面的能力。
Book Description
Get hands-on, practical guidance for using Microsoft SQL Server Integration Services, the next generation data integration platform from Microsoft. Integration Services is a powerful tool for business intelligence, so understanding the essentials--how to develop and deploy SSIS packages, as well as how to apply these skills to data warehousing solutions--is 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 you're a beginning programmer or new to this version of the technology, you'll understand the fundamental techniques for using SQL Server 2005 Integration Services. A companion CD includes data sets and sample code.
From the Publisher
Key Book Benefits:
-Provides hands-on exercises that help develop proficiency quickly
-Features expertise from Hitachi Consulting, which creates specialized SQL Server-based data solutions for corporate customers
-Includes a companion CD with sample data sets and code
Table of Contents
Microsoft SQL Server 2005 Integration Services Step by Step
Introduction
Part I - Getting Started with Integration Services
Chapter 1 - Introduction to SQL Server Integration Services
Chapter 2 - Building Your First Package
Part II - Designing Packages
Chapter 3 - Extracting and Loading Data
Chapter 4 - Using Data Flow Transformations
Chapter 5 - Managing Control Flow
Chapter 6 - Scripting Tasks
Chapter 7 - Debugging Packages
Chapter 8 - Managing Package Execution
Part III - Managing Packages
Chapter 9 - Detecting and Handling Processing Errors
Chapter 10 - Securing and Deploying SSIS Packages
Chapter 11 - Optimizing SSIS Packages
Part IV - Applying SSIS to Data Warehousing
Chapter 12 - Data Warehouse Concepts
Chapter 13 - Populating Data Warehouse Structures
Chapter 14 - SSIS General Principles
Index
List of Figures
List of Tables
List of Sidebars
CD Content
