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

    Question

  • 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.

     


    ProQuest
    Thursday, October 14, 2010 3:55 PM

Answers

  • Have you considered... SSMA? SQL Server Migration Assistance for Access? http://www.microsoft.com/downloads/en/details.aspx?FamilyID=5abe098d-c7e1-46c6-994a-09a2856eef0b&displaylang=en
    Thanks. Mohit. -------------------------------------- MCTS: SQL Server 2005, MCITP: Database Administrator. http://sqllearnings.blogspot.com/
    Thursday, October 14, 2010 7:55 PM