SQL Server Technical Article
Writers: Runying Mao, Carla Sabotta
Technical Reviewers: David Noor, Jeanne Baker
Published: November 2011
Applies to: SQL Server 2012
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.
To review the document, please download the 5 Tips for a Smooth SSIS Upgrade to SQL Server 2012 Word document.
Ask a question in the SQL Server Forums