Microsoft SQL Server 2000.pdf

2000

Data Transformation Services

SQL Server

Timothy Peterson

201 West 103rd St., Indianapolis, Indiana, 46290 USA

Microsoft

Microsoft SQL Server 2000

Data Transformation Services

retrieval system, or transmitted by any means, electronic, mechanical, photo-

copying, recording, or otherwise, without written permission from the pub-

lisher. 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.

International Standard Book Number: 0-672-32011-8

Library of Congress Catalog Card Number: 00-103543

Printed in the United States of America

First Printing: December 2000

03 02 01 00

A CQUISITIONS E DITOR

Sharon Cox

D EVELOPMENT E DITOR

Kevin Howard

E XECUTIVE E DITOR

Rosemarie Graham

M ANAGING E DITOR

Charlotte Clapp

P ROJECT E DITOR

Elizabeth Finney

C OPY E DITOR

Sean Medlock

I NDEXER

Tina Trettin

4 3 2 1

P ROOFREADER

Tony Reitz

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.

Microsoft is a registered trademark of Microsoft Corporation.

SQL Server is a trademark of Microsoft Corporation.

T ECHNICAL E DITORS

Todd Meister

Ivan Oss

T EAM C OORDINATOR

Pamalee Nelson

M EDIA D EVELOPER

JG Moore

Warning and Disclaimer

Every effort has been made to make this book as complete and as accurate as

possible, 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 aris-

ing from the information contained in this book or from the use of programs

accompanying it.

I NTERIOR D ESIGNER

Anne Jones

C OVER D ESIGNER

Anne Jones

Overview

P ART I Getting Started with DTS

1A Quick Look at DTS 5

2 DTS Enhancements for SQL Server 2000 41

3 DTS and the Flow of Data Through the Enterprise 59

4 Using DTS to Move Data into a Data Mart 77

P ART II DTS Connections and the Data Transformation Tasks

5 DTS Connections 101

6he Transform Data Task 125

7Writing ActiveX Scripts for a Transform Data Task 179

8he Data Driven Query Task 213

9he Multiphase Data Pump 227

10 The Parallel Data Pump Task 247

P ART III Other Data Movement and Manipulation Tasks

11 The Bulk Insert Task 267

12 The Execute SQL Task 291

13 The Copy SQL Server Objects Tasks 309

14 The File Transfer Protocol (FTP) Task 325

15 The Transfer Database and Other Transfer Tasks 333

P ART IV Control Tasks

16 Writing Scripts for an ActiveX Script Task 345

17 The Dynamic Properties Task 365

18 The Execute Package Task 377

19 The Message Queue Task 391

20 The Send Mail Task 405

21 The Analysis Services Tasks 411

22 The Execute Process Task 425

P ART V DTS Packages and Steps

23 The DTS Package and Its Properties 435

24 Steps and Precedence Constraints 469

25 Rapid Development with the Copy Database Wizard and the DTS Import/Export

Wizard 501

26 Managing Packages with Visual Basic and Stored Procedures 525

27 Handling Errors in a Package and Its Transformations 553

28 High-Performance DTS Packages 565

29 Integrating DTS with Meta Data Services 587

P ART VI Extending the Power of DTS

30 Programming with the DTS Object Model 611

31 Creating a Custom Task in VB 633

32 Creating a Custom Transformation with VC++ 659

Index 679

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: