Hello! I create packages dynamically for each process (import, export and etc) and render XML. The package is executed using the code below: var p = new Microsoft.SqlServer.Dts.Runtime.Package(); p.LoadFromXML(ssisPackage.RenderXml(), null);Microsoft.SqlServer.Dts.Runtime.DTSExecResult result = p.Execute(); The structure of XML has 2008R2 format. But now we need to migrate to 2012 version and we have to rewrite package XML renderer what will take some time. Is it possible to execute 2008R2 packages using 2012 Integration Services programmatically? Thank you.Software Engineer, MCPD [ Don't forget to mark the post if it is helpful]

It is, infact all you have to do is to upgrade the legacy package(s) to the new deployment model/ Check these http://www.bidn.com/blogs/DustinRyan/bidn-blog/2610/upgrade-2005-2008-ssis-packages-to-2012-like-a-boss and http://msdn.microsoft.com/en-us/library/cc280547.aspxPlease vote as helpful or mark as answer, if it helps Cheers, Raunak | t: @raunakjhawar | My Blog

I can't update package because I create it programmatically each time I need to make an import / export.Software Engineer, MCPD [ Don't forget to mark the post if it is helpful]