SQL 7 to 2000 conversion and DTS

• rnelson_shs

  Old Hand

  Points: 368

  More actions

  January 16, 2003 at 8:38 am

  #105432

  A question: do DTS packages automatically upgrade to SQL Server 2000 when upgrading a server and databases from 7.0? An upgrade coming soon is the first one at my site that utilizes DTS packages and I want to be ready.

• jfb

  SSCrazy

  Points: 2469

  More actions

  January 16, 2003 at 9:03 am

  #446519

  I think you wont have any problems but of course always is good to have a backup of you DTS pkg.

  Here is a good article about transfering DTS pkgs...you should read, also here is a good backup tool for DTS pkgs.

  http://www.sqldts.com/default.aspx?6,105,204,0,0

  Johnny