SQL Server DTS Designer Components installed but can not find on the computer


  • Hi,

    I am in urgent need of help.

    I have MS Access database to be converted into the SQL Server database.

    Now I downloaded and installed MS SQL Server 2005 Management Studio and connected to the SQL Server database.

    Now, I have to import the Access data in SQL server through SQL Server 2000 Import/Export client tool, for which I installed SQL Server 2000 DTS Designer COmponent.

    I was able to install in the computer but I can not find any component on my computer.

    I checked C:\Program Files\Microsoft SQL Server\90\    but I did not find any DTS\Binn\Dts*.exe there.  I do not know how and where to start the wizard to get the Import/Export utility.

    I also checked in explorer Start->All Programs , menu but only See MS SQL Server 2005 and nothing related to DTS.


    Please let me know what should I do and where to look for the components on my computer.


    Thursday, October 14, 2010 3:55 PM


  • Have you considered... SSMA? SQL Server Migration Assistance for Access?
    Thanks. Mohit. -------------------------------------- MCTS: SQL Server 2005, MCITP: Database Administrator.
    Thursday, October 14, 2010 7:55 PM