Click here to Skip to main content
14,735,876 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi,

we would like to copy the tables with all content from one DB to another on a different server. We are using SQLSserver 2005. We couldn't get import and export wizard in task menu. We tried to install SQLServer2005_DTS.msi. We could't find the file 'C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe'


Please help!


Thank you,
Soumya
Posted
Updated 28-Jan-11 0:46am
v2

The import/export wizard can be found by following these steps:
1. Connect the sql server where you want to have the data.
2. Select the database in which you want to create table and import data.
3. Right click on the database and select Tasks from the window.
4. The third last option is to import data. Selecting it will launch the wizard.

The SQLServer2005_DTS.msi is the utility to install the DTS Designer on Sql 2005.
However, Import Data wizard creates an SSIS package which does not need the DTS Designer.

Hope this helps you.
   
Comments
Abdul_Hafeez 28-Jan-11 6:41am
   
This is the good replacement of Data Import and EXportsuing DTS Packages.
Hai,

Thank you for your Response.

In task menu we can't find import and export
we need to imports table data from remote server to our DB

how to implement using query

Pls help

Thank you,
Soumya
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900