discontinued features between sql 2000 and sql 2008

• UncleBoris

  SSCrazy

  Points: 2018

  More actions

  August 6, 2009 at 3:40 pm

  #208359

  Hello, we are in the process of planning SQL 2000 upgrade to SQL 2008 64-bit.

  It will be a clean install.

  Would anybody know where to find a list of any T-SQL that is discontinued between SQL 2000 and SQL 2008.

  Does anybody know if SQL 2008 has the ability to run the DTS Package Emulator so DTS packages can work as in SQL 2000 as normal while they are changed over in time?

  Thanks

• Grant Fritchey

  SSC Guru

  Points: 398999

  More actions

  August 7, 2009 at 6:44 am

  #1035942

  You can get the list of deprecated items from a search on MSDN. You can run DTS inside SSIS, but the behavior is very inconsistent. You'll need to do a lot of testing. I'd suggest looking into DTSXchange. It's a conversion package from PragmaticWorks. It'll save you a lot of headaches.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning