Import / Export wizard missing in task menu

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

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 27-Jan-11 23:43pm

soumyaraj

Updated 27-Jan-11 23:46pm

Manfred Rudolf Bihy

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Umair Feroze · Answer 1 · 2011-01-28T00:01:00

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.

soumyaraj · Answer 2 · 2011-01-28T00:40:00

Solution 2

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

Posted 28-Jan-11 0:40am