Best of MSDN Blogs - 5 Tips for a Smooth SSIS Upgrade to SQL Server 2012

Just perusing the MSDN blogs looking for some SQL Server 2012 blogs, and lo and behold, I can’t really find any over the past week or two.  I guess the team is leaving the demos of the new syntax and other features up to bloggers or others, no idea. I did manage to find one entitled Microsoft SQL Server 2012 - 5 Tips for a Smooth SSIS Upgrade to SQL Server 2012 on the SSIS Team Blog. Here’s the skinny:

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.

Download the white paper and check out the two wizards that are available to ensure a smooth upgrade of your packages and project as you move it to SQL Server 2012. Within the doc, there are several other links that you also might want to read.

Lee

-----------------------------

http://blogs.msdn.com/b/mattm/archive/2011/11/30/5-tips-for-a-smooth-ssis-upgrade-to-sql-server-2012.aspx

http://msdn.microsoft.com/en-us/library/hh667275(d=lightweight).aspx