任务菜单中缺少导入/导出向导 [英] Import / Export wizard missing in task menu

问题描述

我们希望将包含所有内容的表从一个数据库复制到另一台服务器上的另一个数据库.我们正在使用SQLSserver2005.无法在任务菜单中获取导入和导出向导.我们尝试安装SQLServer2005_DTS.msi.我们找不到文件''C:\ Program Files \ Microsoft SQL Server \ 90 \ DTS \ Binn \ DTSWizard.exe''


请帮忙！


谢谢
Soumya

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

推荐答案

可以通过以下步骤找到导入/导出向导:
1.将sql服务器连接到要获取数据的位置.
2.选择要在其中创建表和导入数据的数据库.
3.右键单击数据库，然后从窗口中选择任务".
4.第三个最后一个选项是导入数据.选择它会启动向导.

SQLServer2005_DTS.msi是用于在Sql 2005上安装DTS设计器的实用程序. 但是，导入数据向导会创建一个不需要DTS设计器的SSIS包.

希望对您有帮助.

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.

Hai，

感谢您的回应.

在任务菜单中，我们找不到导入和导出
我们需要将表数据从远程服务器导入到我们的数据库中

如何使用查询实现

请帮助

谢谢
Soumya

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

这篇关于任务菜单中缺少导入/导出向导的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！