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, but are replaced by parameters. If you want to use package configuration you can still be on legacy Package Deployment Model. But don't worry, because parameters in Project Deployment Model do everything package configuration did earlier and also...