没有合适的资源?快使用搜索试试~ 我知道了~
首页Microsoft SQL Server 2008 Integration Services
Microsoft SQL Server 2008 Integration Services
5星 · 超过95%的资源 需积分: 10 49 下载量 4 浏览量
更新于2023-07-05
评论
收藏 12.7MB PDF 举报
讲述了什么是Microsoft SQL Server 2008 Integration Services,我们为什么需要它以及更多你想要了解的内容。
资源详情
资源评论
资源推荐
Microsoft
®
SQL Server
™
2008 Integration
Services
UNLEASHED
800 East 96th Street, Indianapolis, Indiana 46240 USA
Kirk Haselden
Microsoft® SQL Server™ 2008 Integration Services Unleashed
Copyright © 2009 by Pearson Education, Inc.
All rights reserved. No part of this book shall be reproduced, stored in a retrieval
system, or transmitted by any means, electronic, mechanical, photocopying, recording,
or otherwise, without written permission from the publisher. No patent liability is
assumed with respect to the use of the information contained herein. Although every
precaution has been taken in the preparation of this book, the publisher and author
assume no responsibility for errors or omissions. Nor is any liability assumed for
damages resulting from the use of the information contained herein.
ISBN-13: 978-0-672-33032-2
ISBN-10: 0-672-33032-6
Library of Congress Cataloging-in-Publication Data:
Haselden, Kirk.
Microsoft SQL server 2008 integration services unleashed / Kirk Haselden. -- 1st ed.
p. cm.
ISBN 978-0-672-33032-2
1. Database management. 2. SQL server. 3. Data warehousing. I. Title.
QA76.9.D3H3685 2009
005.4'476--dc22
2008050781
Printed in the United States of America
First Printing February 2009
Trademarks
All terms mentioned in this book that are known to be trademarks or service marks
have been appropriately capitalized. Sams Publishing cannot attest to the accuracy of
this information. Use of a term in this book should not be regarded as affecting the
validity of any trademark or service mark.
Warning and Disclaimer
Every effort has been made to make this book as complete and as accurate as possi-
ble, but no warranty or fitness is implied. The information provided is on an “as is”
basis. The author and the publisher shall have neither liability nor responsibility to any
person or entity with respect to any loss or damages arising from the information
contained in this book.
Bulk Sales
Sams Publishing offers excellent discounts on this book when ordered in quantity for
bulk purchases or special sales. For more information, please contact:
U.S. Corporate and Government Sales
1-800-382-3419
corpsales@pearsontechgroup.com
For sales outside of the U.S., please contact:
International Sales
international@pearson.com
Editor-in-Chief
Karen Gettman
Executive Editor
Neil Rowe
Acquisitions Editor
Brook Farling
Development Editor
Mark Renfrow
Managing Editor
Patrick Kanouse
Project Editor
Mandie Frank
Copy Editors
Barbara Hacha
Geneil Breeze
Indexer
Tim Wright
Proofreader
Water Crest
Publishing, Inc.
Technical Editor
Matt David
Publishing
Coordinator
Cindy Teeters
Designer
Gary Adair
Compositor
Mark Shirar
Contents at a Glance
Foreword ......................................................................................xx
Part I Getting Started
1 What Is Integration Services and Why Do I Need It?....................................3
2 Setting Up Integration Services ......................................................................9
3 What’s New in Integration Services 2008 ....................................................21
4 Migrating to Integration Services 2008 ........................................................27
Part II Integration Services Basics
5 The Business Intelligence Development Studio ...........................................41
6 The Building Blocks of Integration Services.................................................89
7 Grouping Control Flow with Containers.....................................................99
8 Building a Package—Quick Start ................................................................119
Part III Control Flow Services
9 The Venerable Variable ...............................................................................137
10 Using Expressions .......................................................................................151
11 The Stock Tasks and Connection Managers...............................................169
12 Using the Script Task ..................................................................................259
13 Using the Data Profiling Task .....................................................................279
14 Logging and the Stock Log Providers .........................................................295
15 Looping and Foreach Enumerators ............................................................313
Part IV Management Services
16 SQL Server Management Studio .................................................................337
17 Using Source Control..................................................................................351
18 Securing Packages........................................................................................361
Part V The Data Flow Task
19 Introducing the Data Flow Task .................................................................377
20 The Stock Data Flow Components .............................................................385
21 Using the Script Component......................................................................445
22 Advanced Data Flow Transformations .......................................................463
23 Data Flow Task Internals and Tuning.........................................................499
Part VI Solving Common Challenges
24 Configuring and Deploying Solutions .......................................................525
25 Common Challenges ..................................................................................557
Part VII Advanced Package Concepts and Patterns
26 Troubleshooting Packages...........................................................................575
27 Building Advanced Packages ......................................................................589
Part VIII Programming Integration Services
28 Building Custom Tasks ...............................................................................607
29 Building Custom Data Flow Components .................................................665
Index
.........................................................................................705
Table of Contents
Foreword ......................................................................................xx
Part I Getting Started
1 What Is Integration Services and Why Do I Need It? 3
What Is SQL Server Integration Services? ......................................................3
Data Import/Export Wizard...................................................................3
ETL Tool .................................................................................................3
Control Flow Engine .............................................................................4
Application Platform .............................................................................4
High Performance Data Transformation Data Pipeline ........................4
A Short Integration Services History ..............................................................4
How This Book Is Organized ..........................................................................5
The Sample Projects ........................................................................................6
Summary .........................................................................................................7
2 Setting Up Integration Services 9
Installing IS .....................................................................................................9
Setting Up Integration Services ...........................................................10
Setting Up Book Samples..............................................................................16
Where Are the Components Installed? ........................................................17
Business Intelligence Development Studio .........................................17
Management Studio ............................................................................17
Import/Export Wizard .........................................................................17
Copy Database Wizard ........................................................................17
The DTS Package Migration Wizard....................................................18
SSIS Package Upgrade Wizard..............................................................18
Data Profile Viewer ..............................................................................18
DTExec, DTUtil ....................................................................................18
DTExecUI .............................................................................................18
Helpful Resources..........................................................................................18
SQL Server 2008 Setup and Upgrade Forum.......................................19
Books Online .......................................................................................19
SQLIS.COM ..........................................................................................19
Blogs.....................................................................................................19
MSDN...................................................................................................20
The SQL Server Integration Services Forum........................................20
Summary .......................................................................................................20
Contents
v
剩余785页未读,继续阅读
claro
- 粉丝: 805
- 资源: 37
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- zigbee-cluster-library-specification
- JSBSim Reference Manual
- c++校园超市商品信息管理系统课程设计说明书(含源代码) (2).pdf
- 建筑供配电系统相关课件.pptx
- 企业管理规章制度及管理模式.doc
- vb打开摄像头.doc
- 云计算-可信计算中认证协议改进方案.pdf
- [详细完整版]单片机编程4.ppt
- c语言常用算法.pdf
- c++经典程序代码大全.pdf
- 单片机数字时钟资料.doc
- 11项目管理前沿1.0.pptx
- 基于ssm的“魅力”繁峙宣传网站的设计与实现论文.doc
- 智慧交通综合解决方案.pptx
- 建筑防潮设计-PowerPointPresentati.pptx
- SPC统计过程控制程序.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论4