Submitted by: Submitted by yeqifan
Views: 10
Words: 2127
Pages: 9
Category: Business and Industry
Date Submitted: 09/26/2015 12:59 AM
5 Tips for a Smooth SSIS Upgrade to
SQL Server 2012
Runying Mao, Carla Sabotta
Summary:Microsoft SQL Server 2012 Integration Services (SSIS) provides significant
improvements in both the developer and administration experience. This article provides
tips that can help to make the upgrade to Microsoft SQL Server 2012 Integration
Services successful. The tips address editing package configurations and specifically
connection strings, converting configurations to parameters, converting packages to the
project deployment model, updating Execute Package tasks to use project references
and parameterizing the PackageName property.
Category:Quick Guide
Applies to: SQL Server 2012
Source:White paper (link to source content)
E-book publication date: November 2012
Copyright © 2012 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.
Microsoft and the trademarks listed at
http://www.microsoft.com/about/legal/en/us/IntellectualProperty/Trademarks/EN-US.aspx are trademarks of the
Microsoft group of companies. All other marks are property of their respective owners.
The example companies, organizations, products, domain names, email addresses, logos, people, places, and events
depicted herein are fictitious. No association with any real company, organization, product, domain name, email address,
logo, person, place, or event is intended or should be inferred.
This book expresses the author’s views and opinions. The information contained in this book is provided without any
express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or distributors
will be held liable for any damages caused or alleged to be caused either directly or indirectly by this book.
2
Contents
Introduction...