SQL Server Integration Services Using Visual Studio 2005 A Beginners Guide Jayaram Krishnaswamy BIRMINGHAM - MUMBAI SQL Server Integration Services Using Visual Studio 2005 A Beginners Guide Copyright © 2007 Packt Publishing All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews. Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, Packt Publishing, nor its dealers or distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book. Packt Publishing has endeavored to provide trademark information about all the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information. First published: December 2007 Production Reference: 1171207 Published by Packt Publishing Ltd. 32 Lincoln Road Olton Birmingham, B27 6PA, UK. ISBN 978-1-847193-31-5 www.packtpub.com Cover Image by Nikhil Bangera (
[email protected]) Credits Author Jayaram Krishnaswamy Reviewer Anand Narayanaswamy Senior Acquisition Editor Douglas Paterson Development Editor Rashmi Phadnis Technical Editor(s) Project Manager Patricia Weir Project Coordinator Abhijeet Deobhakta Indexer Monica Ajmera Proofreader Cathy Cumberlidge Production Coordinator Ajay.S Aparna Bhagat Sarvesh Shanbag Shantanu Zagade Editorial Team Leader Mithil Kulkarni Cover Designer Aparna Bhagat About the Author Jayaram Krishnaswamy has been working in IT related fields since 1997. He was once a Microsoft Certified Trainer in Networking and a Siebel developer. He has worked with several IT related companies, such as Butler International in their Siebel practice; several other IBM sub-contractors, and smaller companies. At present, he is active in writing technical articles in the IT field to many online sites such as Code Project.com, ASPFree.com, DevShed.com, DevArticles.com, OfficeUsers.com, Aspalliance.com, and many others. During 2006-2007 he wrote more than 200 articles, mostly related to database and web-related technologies covering Microsoft, Oracle, Sybase, ColdFusion, Sun, and other vendor products. Acknowledgements First of all, I would like to thank Dr. Douglas Paterson, the Senior Acquisition Editor, for encouraging me to write this book and giving his time generously. When I was toying with the idea of combining DTS and SSIS in one book, he persuaded me to stick with SSIS. I am most grateful for this suggestion as I can see now that the book is better focused. He was also instrumental in guiding me when I was writing the initial chapters that form the foundation for the rest of the book. I would like to thank Abhijeet Deobakta, the Project Manager, for