Microsoft SQL Server 2008 Integration Services Unleashed [Sams].pdf

(18409 KB) Pobierz
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
Kirk Haselden
Microsoft ®
SQL Server ™
2008 Integration
Services
UNLEASHED
800 East 96th Street, Indianapolis, Indiana 46240 USA
879311557.005.png 879311557.006.png 879311557.007.png 879311557.008.png
 
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
Editor-in-Chief
Karen Gettman
Executive Editor
Neil Rowe
Acquisitions Editor
Brook Farling
Development Editor
Mark Renfrow
Managing Editor
Patrick Kanouse
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
Project Editor
Mandie Frank
Copy Editors
Barbara Hacha
Geneil Breeze
Indexer
Tim Wright
2008050781
Printed in the United States of America
First Printing February 2009
Proofreader
Water Crest
Publishing, Inc.
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.
Technical Editor
Matt David
Publishing
Coordinator
Cindy Teeters
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.
Designer
Gary Adair
Compositor
Mark Shirar
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
879311557.001.png
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
879311557.002.png
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
879311557.003.png
Contents
v
Table of Contents
Part I
Getting Started
1
Data Import/Export Wizard...................................................................3
ETL Tool .................................................................................................3
Control Flow Engine .............................................................................4
Application Platform .............................................................................4
High Performance Data Transformation Data Pipeline ........................4
2
Setting Up Integration Services ...........................................................10
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
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
879311557.004.png

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin