SQL Server 2000 DTS package in 2005??

• BC-36233

  SSC-Addicted

  Points: 486

  More actions

  March 27, 2006 at 7:52 am

  #168320

  Hello All,

  I have a sql server 2000 database with several DTS packages that get called during the running of my application. We recently moved to a new windows 2003 box with sql server 2005 on it. However I can't shut down the old sql server till I can figure out how to run my sql 2k dts packages on the new sql2005 server. I tried to import the packages and it says they are there, but I can't seem to call them from my application. So really what I'd like to do is take advantage of the BI. But how is that done? Should I do that ?What would be recommended? Thanks for any pointers and or suggestions.

  Brian

• Dan Jones-279024

  Ten Centuries

  Points: 1362

  More actions

  March 28, 2006 at 9:29 am

  #629224

  Hi Brian,

  There are a number of good topics in SQL Server Books Online on running DTS 2000 packages in SQL Server 2005 (Integration Services). Here's a good place to start: http://msdn2.microsoft.com/en-us/library/ms143706(SQL.90).aspx

  Cheers,

  Dan