does dts packages run on sql server 2008 on windows 2008 server

• gary1

  SSC-Insane

  Points: 21152

  More actions

  July 26, 2010 at 3:35 pm

  #238127

  Hi,

  We have a DTS package in SQL Server 2005 EE x64 with SP3 on Windows server 2003

  Now we are upgrading to SQL Server 2008 SP1 x64 on Windows Server 2008 x64

  does dts packages run on sql server 2008 on windows 2008 server?

  thanks

• SQLRNNR

  SSC Guru

  Points: 281344

  More actions

  July 26, 2010 at 3:50 pm

  #1198466

  Yes they do.

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events

• SQLRNNR

  SSC Guru

  Points: 281344

  More actions

  July 26, 2010 at 3:53 pm

  #1198469

  Should have added, I am currently running numerous DTS packages on SQL 2008 with Win 2008 R2 64 bit.

  I have written a little bit about it in my blog.

  http://jasonbrimhall.info/2010/07/07/sql-2008-dts/

  and

  http://jasonbrimhall.info/2010/07/23/a-little-dance-with-ssis-and-informix/

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  July 26, 2010 at 4:18 pm

  #1198481

  They will run fine.

  Best Regards,

  SQLBuddy