Upgrading MSSQL 2008 to MSSQL 2012

• kimball.cook

  Grasshopper

  Points: 11

  More actions

  June 13, 2013 at 11:37 am

  #278570

  We are upgrading our MSSQL2008 DB server to MSSQL2012. Being new to MSSQL2012. My question is will the SSIS packages we have stored in the database be convert as well or do we have to reload them after they have been convert from VS2008 to VS2012?

  Thanks in advance.

  Kimball

• Tommy Bollhofer

  SSChampion

  Points: 14940

  More actions

  June 13, 2013 at 11:54 am

  #1623841

  The packages aren't automatically upgraded to the SQL Server 2012 package format.

  Per BOL -

  "At runtime DTEXEC uses temporary upgrade process for an existing SQL Server 2005 or 2008 package that may increase execution time."

  More information available via:

  http://www.sqlservercentral.com/blogs/dknight/2012/05/16/upgrading-packages-to-ssis-2012/%5B/url%5D

  http://msdn.microsoft.com/en-us/library/cc280546.aspx

  Tommy

  Follow @sqlscribe