SQL Server Express DTS how to install RRS feed

  • Question

  • User1416329745 posted

    It is not full DTS it is a limited version of DTS provided to read SQL Server 2000 DTS files and copy databases, it came with 2005 service pack 1 but it will not install by default.  The thread below explains how to rerun the service pack setup and install it.  Hope this helps.


    Wednesday, November 8, 2006 6:03 PM

All replies

  • User-1573490007 posted

    Thank you Caddre.

    When I installed it after reading your post, I just downloaded the SP1, and selected all the options I could. The upgrade failed at the database level (so I don't have SP1 installed), but the DTS was still installed, fortunately.

    So people reading this, if the upgrade fails, don't worrie!

    Wednesday, November 8, 2006 6:27 PM
  • User1416329745 posted


    It failed because It is not an upgrade it is a simple service pack one you can open it I usually do it is nothing but .sql files SQL Server and Windows uses as needed, because if you run this service pack with the developer edition and above, it will not install DTS because it is not needed DTS in the full editions is SSIS(integration services) part of the second management studio the one for BI(Business Intelligence)

    Wednesday, November 8, 2006 7:29 PM
  • User-1573490007 posted
    Actualy in this case thats just the thing, the service pack install failed (mostly because of a permission issue that I have since resolved). Its not a big deal. I just mentionned it in case someone has the same issue: the Service Pack doesn't even have to install correctly, as long as the client tools get there, as it doesn't rollback anything.
    Wednesday, November 8, 2006 7:56 PM