Solved

Where is the DTS Import/Export Wizard on SQL Server 2005?

Posted on 2007-04-10
4
486 Views
Last Modified: 2012-08-13
I am trying to import an Access 2003 Database into my SQL Server 2005.  However, there is no Enterprise Manager with SQL Server 2005 Evaluation version. I downloaded the SQL Server Management Studio Express and it does not have any import function in it.

Thanks.
0
Comment
Question by:billyboy71
4 Comments
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 18883697
do you mean  SSIS?

right click the database
select tasks
and Import/export data is near the bottom of the second drop down
0
 
LVL 16

Accepted Solution

by:
rboyd56 earned 250 total points
ID: 18883700
The SQL Server 2005 Evaluation Edition should have Management Studio with it. Did you install teh Workstation components when you ran setup?

I do not know where it is in the Express Edition of Management Studio, but in the version that comes with SQL Server 2005 you get to the Import Wizard by right clicking on the Management folder under the SQL Server tree.
0
 
LVL 27

Expert Comment

by:ptjcb
ID: 18884139
SQL Server Integration Services is not available in SQL Server 2005 Express Edition.

You should check your installation for the SQL 2005 Enterprise Evaluation edition. Did you select the Integration Services on the Components to Install page of the installation wizard?

Do you have Visual Studio installed? Have you started a VS project and selected SQL Server Integration?
0
 

Author Comment

by:billyboy71
ID: 18890653
Good
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now