O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Migrating packages to 2012

SSIS 2012 is the latest version of SSIS and packages which were developed and created by SSIS 2005 and 2008 can be converted to the 2012 version simply with help of the Project Conversion Wizard. But there are a few exceptions.

As we mentioned earlier, the ActiveX Script Task and Execute DTS 2000 Package Task are no longer supported in SSIS 2012, so packages with these tasks should use alternative options. For ActiveX Script Task a much better alternative is Script Task with support of .NET 4.0 Framework. And the alternative for Execute DTS 2000 Package Task is Execute Package Task which works with SSIS packages.

Another thing to note in SSIS 2012 package is that configurations no longer exist in Project Deployment Model, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required