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.
View Complete Post