Microsoft SQL Server 2000 Data Transformation Services- P1

Microsoft SQL Server 2000 Data Transformation Services- P1: Data Transformation Services in Microsoft SQL Server 2000 is a powerful tool for movingdata. It’s easy to use, especially when you’re creating transformation packages with the DTSWizard. But it’s also a flexible tool that you can customize to gain a high degree of controlover the transformation of your data.
Nội dung trích xuất từ tài liệu:
Microsoft SQL Server 2000 Data Transformation Services- P1Please purchase PDF Split-Merge on www.verypdf.com to remo Microsoft SQL Server 2000  Data Transformation Services Timothy Peterson 201 West 103rd St., Indianapolis, Indiana, 46290 USA ACQUISITIONS EDITORMicrosoft SQL Server 2000 Sharon CoxData Transformation Services DEVELOPMENT EDITORCopyright © 2001 by Sams Publishing Kevin HowardAll rights reserved. No part of this book shall be reproduced, stored in a EXECUTIVE EDITORretrieval system, or transmitted by any means, electronic, mechanical, photo- Rosemarie Grahamcopying, recording, or otherwise, without written permission from the pub-lisher. No patent liability is assumed with respect to the use of the information MANAGING EDITORcontained herein. Although every precaution has been taken in the preparation Charlotte Clappof this book, the publisher and author assume no responsibility for errors or PROJECT EDITORomissions. Nor is any liability assumed for damages resulting from the use of Elizabeth Finneythe information contained herein.International Standard Book Number: 0-672-32011-8 COPY EDITOR Sean MedlockLibrary of Congress Catalog Card Number: 00-103543 INDEXERPrinted in the United States of America Tina TrettinFirst Printing: December 2000 PROOFREADER03 02 01 00 4 3 2 1 Tony Reitz TECHNICAL EDITORSTrademarks Todd MeisterAll terms mentioned in this book that are known to be trademarks or service Ivan Ossmarks have been appropriately capitalized. Sams Publishing cannot attest tothe accuracy of this information. Use of a term in this book should not be TEAM COORDINATORregarded as affecting the validity of any trademark or service mark. Pamalee NelsonMicrosoft is a registered trademark of Microsoft Corporation. MEDIA DEVELOPER JG MooreSQL Server is a trademark of Microsoft Corporation. INTERIOR DESIGNERWarning and Disclaimer Anne JonesEvery effort has been made to make this book as complete and as accurate as COVER DESIGNERpossible, but no warranty or fitness is implied. The information provided is on Anne Jonesan “as is” basis. The author and the publisher shall have neither liability norresponsibility 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 programsaccompanying it.Overview PART I Getting Started with DTS 1 A 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 PART II DTS Connections and the Data Transformation Tasks 5 DTS Connections 101 6 The Transform Data Task 125 7 Writing ActiveX Scripts for a Transform Data Task 179 8 The Data Driven Query Task 213 9 The Multiphase Data Pump 227 10 The Parallel Data Pump Task 247 PART 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 PART IV Control Tasks 16 Writing Scripts for an ActiveX Script Task 345 17 ...