Brian Knight - Knights Microsoft SQL Server 2012 Integration Services 24-Hour Trainer

Knights Microsoft SQL Server 2012 Integration 24-Hour Trainer

Published by John Wiley & Sons, Inc.

10475 Crosspoint Boulevard

Indianapolis, IN 46256

www.wiley.com

Copyright 2013 by John Wiley & Sons, Inc., Indianapolis, Indiana

Published simultaneously in Canada

ISBN: 978-1-118-47958-2

ISBN: 978-1-118-47960-5 (ebk)

ISBN: 978-1-118-53914-9 (ebk)

ISBN: 978-1-118-53915-6 (ebk)

Manufactured in the United States of America

10 9 8 7 6 5 4 3 2 1

No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or online at http://www.wiley.com/go/permissions .

Limit of Liability/Disclaimer of Warranty: The publisher and the author make no representations or warranties with respect to the accuracy or completeness of the contents of this work and specifically disclaim all warranties, including without limitation warranties of fitness for a particular purpose. No warranty may be created or extended by sales or promotional materials. The advice and strategies contained herein may not be suitable for every situation. This work is sold with the understanding that the publisher is not engaged in rendering legal, accounting, or other professional services. If professional assistance is required, the services of a competent professional person should be sought. Neither the publisher nor the author shall be liable for damages arising herefrom. The fact that an organization or Web site is referred to in this work as a citation and/or a potential source of further information does not mean that the author or the publisher endorses the information the organization or Web site may provide or recommendations it may make. Further, readers should be aware that Internet Web sites listed in this work may have changed or disappeared between when this work was written and when it is read.

For general information on our other products and services please contact our Customer Care Department within the United States at (877) 762-2974, outside the United States at (317) 572-3993 or fax (317) 572-4002.

Wiley publishes in a variety of print and electronic formats and by print-on-demand. Some material included with standard print versions of this book may not be included in e-books or in print-on-demand. If this book refers to media such as a CD or DVD that is not included in the version you purchased, you may download this material at http://booksupport.wiley.com . For more information about Wiley products, visit www.wiley.com .

Library of Congress Control Number: 2012948658

Trademarks: Wiley, the Wiley logo, Wrox, the Wrox logo, Wrox Programmer to Programmer, and related trade dress are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates, in the United States and other countries, and may not be used without written permission. Microsoft and SQL Server are registered trademarks of Microsoft Corporation. All other trademarks are the property of their respective owners. John Wiley & Sons, Inc., is not associated with any product or vendor mentioned in this book.

To the person who gave me my first chance at writing, Steve Wynkoop.Brian Knight

Philippians 4:13Devin Knight

To my wife Jessy, my son Gabriel, and my daughter Sydney; they are the reason I strive for more.Mike Davis

Vickie is my wifes name. She is patient, where I am impatient. She is at her best when things seem to be at their worst. In my experience, that is a rare trait. Her love, support, and understanding is what allows me, from a personal standpoint, to work on a project such as this. Most of my work on this project has been nights and weekends, in addition to a regular work week. For me, this is not possible without a good home life. Vickiethis is dedicated to you. Wayne Snyder

Brian Knight , SQL Server MVP, MCITP, is the owner and founder of Pragmatic Works. He is the cofounder of BIDN.com, SQLServerCentral.com, and SQLShare.com. He runs the local SQL Server users group in Jacksonville (JSSUG). He is a contributing columnist at several technical magazines. He is the author of 15 SQL Server books. Brian has spoken at conferences like PASS, SQL Connections and TechEd, SQL Saturdays, Code Camps, and many pyramid scheme motivational sessions. His blog can be found at http://www.bidn.com, which covers many BI topics and miniature donkey training tips. Brian lives in Jacksonville, Florida, where he enjoys his kids and running marathons.

Devin Knight is a Senior BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author on the books Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services , Knight's Microsoft Business Intelligence 24-Hour Trainer , and SharePoint 2010 Business Intelligence 24-Hour Trainer . Devin has spoken at past conferences like PASS, SQL Saturdays, and Code Camps and is a contributing member to the PASS Business Intelligence Virtual Chapter. Making his home in Jacksonville, Florida, Devin is the Vice President of the local users group (JSSUG).

Mike Davis , MCTS, MCITP, is the Managing Project Lead at Pragmatic Works. This book is his fourth on the subject of business intelligence and specifically Integration Services. He has worked with SQL Server for almost a decade and has led many successful business intelligence projects with his clients. Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups, Code Camps, SQL Saturday events, and the PASS Summit. Mike is an active member at his local user group (JSSUG) in Jacksonville, Florida. In his spare time, he likes to play darts and guitar. You can also find him on twitter @MikeDavisSQL, and his blog on MikeDavisSQL.com and BIDN.com.

Wayne Snyder has worked as a DBA for about 20 years, learning about databases and the data which they contain. For the past 8 years, he has been entirely focused on business intelligence, using the Microsoft BI Stack for Mariner ( www.mariner-usa.com ). His role at Mariner is Distinguished Architect, and in that role he spends a lot of time with Integration Services, Analysis Services, Reporting Services, and PowerPivot. There are hundreds of packages in production right now that he had a hand in making. He is a SQL Server MVP and a former President of PASS (Professional Association for SQL Server). When he is not working or writing, he plays the keyboard in a regional cover band, Soundbarrier ( www.soundbarrierband.com ).