Microsoft SQL Server 2000 DTS Step by Step

Carl Rabeler.

PUBLISHED BY
Microsoft Press
A Division of Microsoft Corporation
One Microsoft Way
Redmond, Washington 98052-6399

Copyright 2003 by Microsoft Corporation

All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of the publisher.

Library of Congress Cataloging-in-Publication Data
Rabeler, Carl, 1955-
Microsoft SQL Server 2000 DTS Step by Step / Carl Rabeler.
p. cm.
Includes index.
ISBN 0-7356-1916-6
1.  Client/server computing.    2.  SQL server.    I.  Title.

QA76.9.C55R32    2003
005.75 85--dc21 2003051213

Printed and bound in the United States of America.

1 2 3 4  5  6  7  8  9    QWE      8 7 6 5 4 3

Distributed in Canada by H.B. Fenn and Company Ltd.

A CIP catalogue record for this book is available from the British Library.

Microsoft Press books are available through booksellers and distributors worldwide. For further information about international editions, contact your local Microsoft Corporation office or contact Microsoft Press International directly at fax (425) 936-7329. Visit our Web site at www.microsoft.com/mspress. Send comments to mspinput@microsoft.com .

Active Directory, ActiveX, JScript, Microsoft, Microsoft Press, MSDN, Windows, Windows NT, and Windows Server are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries . Other product and company names mentioned herein may be the trademarks of their respective owners .

The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious. No association with any real company, organization, product, domain name , e-mail address, logo, person, place, or event is intended or should be inferred.

Acquisitions Editor:  Juliana Aldous Atkinson
Project Editor:  Jenny Moss Benson
Technical Editor:  Paul Chambre
Copyeditor:  Victoria Thulman
Cover Graphic Designer:  Methodologie
Principal Compositor:  Elizabeth Hansford
Indexer:  Richard Shrout

Body Part No. X09-59423

About the Author

Carl Rabeler is an MCT, MCDBA, and MCSE. In conjunction with the Business Intelligence Practices group at Microsoft, Carl authored the technical documentation for the SQL Server Accelerator for Business Intelligence, the DTS Programming Practices Used in SQL Server Accelerator for Business Intelligence white paper, and the Microsoft Analysis Services Performance Guide white paper. Carl wrote the SQL Server High Availability Series, which is available via MSDN. He also wrote the Microsoft SQL Server 2000 System Administration MCSE Training Kit and the Academic Learning Series course based on that book. Before that, he was a subject matter expert for the Microsoft Official Courseware group from 1995 through 2000, working with both Microsoft SQL Server and Microsoft Exchange Server. Carl has also been an independent software consultant since 1989, developing hardware and software solutions for a variety of customers.