专业SQL服务器2005综合丛书 Professional SQL Server 2005 Integration Services

出版时间：2006-01-31  出版社：Wrox  作者：Brian Knight,Allan Mitchell,Darren Green,Douglas Hinson,Kathi Kellenberger,Andy Leonard,Erik Veerman,Jason Gerard,Haidong Ji,Mike Murphy  页数：692  
Tag标签：无  

内容概要

This book will help you get past the initial learning curve quickly so that you can get started using SSIS to transform data, create a workflow, or maintain your SQL Server. Offering you hands-on guidance, you'll learn a new world of integration possibilities and be able to move away from scripting complex logic to programming tasks using a full-featured language.     What you will learn from this book：    Ways to quickly move and transform data；    How to configure every aspect of SSIS；    How to interface SSIS with web services and XML；    Techniques to scale the SSIS and make it more reliable；    How to migrate DTS packages to SSIS；    How to create your own custom tasks and user interfaces；    How to create an application that interfaces with SSIS to manage the environment；    A detailed usable case study for a complete ETL solution.作者简介：    Brian Knight, SQL Server MVP, MCSE, MCDBA, is the cofounder of SQLServerCentral.com and was recently on the Board of Directors for the Professional Association for SQL Server (PASS). He runs the local SQL Server users group in Jacksonville, Florida (JSSUG). Brian is a contributing columnist for SQL Server Standard and also maintains a weekly column for the database Web site SQLServerCentral.com. He is the author of Admin911: SQL Server (Osborne/McGraw-Hill Publishing) and coauthor of Professional SQL Server DTS and Professional SQL Server 2005 SSIS (Wiley Publishing). Brian has spoken at such conferences as PASS, SQL Connections, and TechEd. His blog can be found at www.whiteknighttechnology.com.

书籍目录

Acknowledgments. Foreword. Introduction.   Who This Book Is For.   How This Book Is Structured.   What You Need to Use This Book.   Conventions.   Source Code.   Errata.   p2p.wrox.com. Chapter 1: Welcome to SQL Server Integration Services. Chapter 2: The SSIS Tools. Chapter 3: SSIS Tasks. Chapter 4: Containers and Data Flow. Chapter 5: Creating an End-to-End Package. Chapter 6: Advanced Tasks and Transforms. Chapter 7: Scripting in SSIS. Chapter 8: Accessing Heterogeneous Data. Chapter 9: Reliability and Scalability. Chapter 10: Understanding the Integration Services Engine. Chapter 11: Applying the Integration Services Engine. Chapter 12: DTS 2000 Migration and Metadata Management. Chapter 13: Error and Event Handling. Chapter 14: Programming and Extending SSIS. Chapter 15: Adding a User Interface to Your Component. Chapter 16: External Management and WMI Task Implementation. Chapter 17: Using SSIS with External Applications. Chapter 18: SSIS Software Development Life Cycle. Chapter 19: Case Study: A Programmatic Example. Index.